How to display a search result based on a dropdown selection

I am a newbie in ASP.net development so please be kind :)
I have a search form with some dropdown that the user can select an option from for a result page:


The Physician's name is populated with the following query:     SELECT * FROM content WHERE folder_id = '188' ORDER BY content_title The Specialties (e.g. Cardiology) is populated with the following query:     SELECT * FROM content WHERE (folder_id IN (SELECT folder_id FROM [content_folder_tbl] WHERE (parent_id = 158) OR (parent_id = 149))) AND (published = 1) AND (UPPER(content_title) NOT LIKE '%DESCRIPTION') AND (UPPER(content_title) NOT LIKE '%IMAGE') ORDER BY content_title The Location (e.g. 1 Theall Road) is populated with the following query:     SEL ...