Hi,does anyone knows how to integrate the search function with a dropdown list on the aspx webpage?

Example....

The database consists of attributes or columns with headers such as
Names | IDs | Locations | Contact No .

The dropdown list is a search filter for various columns in the database such that when a user type something in the textbox, the dropdown list will filter what columns he want to search.

You will have to use a dynamic query. For example if i place the text 'John Doe' in the textbox and the dropdown list has names selected you would build your query like this:

Dim strSQL as string = "SELECT " & dropdown1.selectedItem.Text &" From [table] WHERE " & dropdownlist1.selectedItem.text & " LIKE '%" & textbox1.text &"'"

The comand that will get sent to sql is: SELECT Names From [Table] Where Names Like '%John Doe'

Hth

"The one language all programmers understand is profanity."