Combobox to filter fields in database?

Question

How can I get the fields shown on the database to change depending on what is selected on the combobox? enter image description here Thanks

are you trying to sort the dgv? – Index Nov 30 '14 at 20:10 — Index, Nov 30 '14 at 20:10

score 1 · Answer 1 · answered Nov 30 '14 at 20:41

many ways to do this but i guess bindingsource would be the easiest.

just bind the grid to your datasource using a Bindingsource

then u can filter like

MyBindingSource.Filter = "Forename = Walter"

so with your Combobox it should look like

MyBindingSource.Filter = "Forename = " & ComboBox1.SelectedValue & ""

and to clear the filter

MyBindingSource.RemoveFilter()

1 Answers1