Sorting with textbox

Question

0.00/5 (No votes)

See more:

i m trying to filter datagridview with this code but does not work

productsBindingSource1.Filter = String.Format("ProductName LIKE '{0}%' OR Barcode = '{0}' OR Comment LIKE '%{0}%'", txtSearch.Text);

datagridview source is productsBindingSource1
Can enyone tell why this does not work?

Posted 22-Oct-10 21:04pm

lester555

Add a Solution

Comments

shakil0304003 23-Oct-10 3:17am

What is your problem? Clear it?

thatraja 23-Oct-10 3:21am

show us the error message, if any?

Sandeep Mewara 23-Oct-10 4:26am

Update from OP:
it does not make any error or exeption. when i klick btnSearch it does not anything

Sandeep Mewara 23-Oct-10 4:28am

Winforms or WebApp? You can post here as a comment...

Hiren solanki 23-Oct-10 4:39am

To sandeep:
It seems ASP.Net as OP has mentioned datagridview , I think so.
To OP:
If you are not getting any error then have checked data ? are you binding filtered datasource to grid ? check deeply.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2010-10-22T23:44:00

Check out the property BindingSource.SupportsFiltering and BindingSource.SupportsAdvancedSorting.

It would be no surprise that the data source simply doesn't support advanced filtering (multi-column filtering) or any filtering at all.

Have a look at the DataSource members for more info:
http://msdn.microsoft.com/en-us/library/ms158196%28v=VS.80%29.aspx[^]

Good luck!

T.Saravanann · Answer 2 · 2010-10-23T00:41:00

Solution 3

Hi Lester,

Try the following link its will helpful to you.

Data Filter in DataGridView[^]

Cheers :)

Posted 23-Oct-10 0:41am

T.Saravanann