Member Avatar for Member 784811

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?

  • 2 Contributors
  • 1 Reply
  • 114 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by pritesh2010
Member Avatar for pritesh2010 
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 & ""
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.