How Do I Filtering Data In DataGridView Using 4 ComboBox

Question

1.00/5 (1 vote)

See more:

I have DataGridView that Contains Some Details , I want filter these Data using 4

ComboBoxes .

Thanks For All

I'M Sorry Because My Poor English

This Is An Example
http://www.gulfup.com/?kWMojY[^]

Posted 14-Oct-14 8:41am

Ahmed Dabas

Add a Solution

Comments

Ahmed Dabas 14-Oct-14 14:43pm

my previous post was closed because I could not express

3 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)

Mycroft Holmes · Answer 1 · 2014-10-14T15:33:00

Solution 1

This becomes a design issue. I find that it is best to have the 4 combos and a button that applies the filtering. In the click event of the button you apply the filtering to the underlying data collection based on the selected items of the combo boxes.

The button allows the user to select from each combo and then apply the filter. If you use the change event of the combo's the filtering is prematurely applied based on only the current combo!

Posted 14-Oct-14 15:33pm

Mycroft Holmes

Comments

Ahmed Dabas 15-Oct-14 14:53pm

i want to use change event

Mycroft Holmes 15-Oct-14 18:23pm

Then accept that the filter will be fired EVERY time the user changes any of the 4 values!

Ahmed Dabas 16-Oct-14 4:11am

yes i want this

Ahmed Dabas 16-Oct-14 11:56am

How can i do this

Mycroft Holmes · Answer 2 · 2014-10-19T17:54:00

If you want to do the filtering every time a user changes a combobox selection you need to:

Add an event handler to each combobox for the OnChangeEvent (change to the event view in the properties window and double click on the OnChange)

In each event handler:
Get the selected value from the combobox
Filter the collection populating the datagridview
Note you may need to update the binding of the DGV.

You really need to try and help yourself!

Ahmed Dabas · Answer 3 · 2014-10-19T05:56:00

Solution 2

No one can help me ,
Some one help me

Posted 19-Oct-14 5:56am