I need to design a search/filter for a DataGridView. The search contains 2 comboboxes and 1 textbox. combobox1 are the field names, combobox2 is the criteria (=, <>, like), and the textbox is to input values.

For example:

Users will select the Road Name field from combobox1, "=" from combobox2, and Main St will be typed in the textbox. After a button is pressed, the datagridview should filter to whatever the user inputs.

Any ideas of how I can accomplish this?

or first you can concatinate all the first all three fileds
dim str as string
str=Combo1.SelectedItem & Combo2.selectedItem  & textbox1.text
"Select * from table Where " & str & ""