ASP.NET GridView Filtering

ASP.NET GridView Filtering

In this tutorial you will learn how to add a filter to a Grid View Control, To modify the query with a parameterized filter, the WHERE Clause, Parameter properties, Parameter Value Editor and To test filtering.

Adding Filtering

If the developer wants to display only selected data in a page, the query for the SqlDataSource control will have to be modified. The first step in this process is to add a Textbox control where the users can enter the filter condition. The filter condition then becomes the parameterized filter (WHERE clause).

1. In the Toolbox, from the Standard folder, drag a TextBox control and a Button control onto the page.

2. The Button control is used only to post the page to the server.

3. In the Properties window for the TextBox control, set the ID property to StudentNametext.

4. Type Student Name or similar text before the text box to act as a caption.

5. In the Properties window for the Button control, change the Text property to Submit.

The query will now have to be modified to add the filter.

To modify the query with a parameterized filter

1. Right-click the SqlDataSource control, and then click Show Smart Tag.

2. On the SqlDataSource Tasks menu, click Configure Data Source

3. The Configure Data Source < Datasourcename > wizard appears.

4. Click Next.

5. The wizard displays the SQL command currently configured for the SqlDataSource control.

6. Click WHERE.

7. The Add WHERE Clause page appears.

8. In the Column list, click Student Name.

9. In the Operator list, click =.

10. In the Source list, click Control.

11. Under Parameter properties, in the Control ID list, click StudentNameText.

12. The preceding five steps specify that the query will get the search value for Student Name from the TextBox control that was added in the preceding procedure.

13. Click Add.