Gridview Search: use DropDownList and TextBox to search / filter gridv

[090123123]

Let's say I have a db SQL with Customer_Details and with columns: Customer_id, Customer_Name, Customer_Address. Here's an example of what I want to do:


I want to display all the records in the gridview to start. There would be a dropdownlist that lets the user select item whether to search by customer_id, customer_name, or customer_address and a text box that lets them type in what they want to search for (and a button to start the search)example:when user select item Customer_id in dropdownlist and then user type id as C0001 . After searching, the gridview would only display the records that matched the criteria.

How can I do this by code? Or if you know a tutorial of this that would be fantastic.Thanks all

 

[taree]

Here is a good tutorial:

http://www.maconstateit.net/tutorials/ASPNET20/ASPNET06/aspnet06-06.aspx