pati tamas

pati tamas

  • NA
  • 20
  • 0

multiple-criteria search

Nov 14 2009 3:47 AM

Hello everyone!
I'm new to this site and vb ,find it very useful.
I've got a problem here:
I have a database : DB with a table contains 10 columns. I have created a form : form1, with 3 comboboxes on it : 1,2,3
onev.column------------combobox1
bvnev.column-----------combobox2
tnev.column-------------conbobox3
 
I want to have the  search on this three criteria in any combinations, and show a datagridview with all 10 columns regarding to the search.
How do i fill my comboboxes to fit the search, how do i make multiple search on the 3 criteria, and how do i show it in datagridview ?
I'm using vs 2008 and sql 3.5 ce
Any of your help appriciated !
Excuse my english it is not my mothertongue.
 

Answers (10)