Search with 4 dropdownlists

Question

User-54412917 posted

i have 4 dropdwnlist like attached photo
i want to use logic in search

ex1:
if i select value in dropdownlit 1 and 3 =>search using condtion with logic and(&&)
and neglict other tow dropdownlist 2 and 4


ex2:
if i select value for all 4 dropdownlist
seach in database with and logic in all 4 dropdownlist

like ddl1=val1 && ddl2=val2 && ddl3=val3 && ddl4=val4 &&

the method i want to use working with if statement
and  i will write 16 if statement this will meet all cases
what is the best solution in this seach case

thanks so much

image found in this link

http://www.2shared.com/photo/BBoI82iV/Search.html?

Answer 1

User-1199946673 posted

You can do it all in one statement using Optional Search Criteria...

 http://www.mikesdotnetting.com/Article/68/An-ASP.NET-Search-Engine-with-MS-Access-for-optional-search-criteria

Answer 2

User-54412917 posted

it is exactly i want
many many thanks for you
it works good

thanks to allah