山豬大哥的菜籃子

Filter A GridView After The Initial Bind

One of the goals that Microsoft has really pushed for in ASP.NET 2.0 is saving the amount of coding necessary to perform common tasks such as data access. On a recent project, I needed the ability to filter the results on a GridView control after I returned the results from my datasource. To accomplish this, I added a DropDownList and set the AutoPostBack property on the DropDownList to True. I added two values to the list; one that showed all of the results, and one that showed the filtered result set which in my case was a list of exceptions. I also added a SqlDataSource object called MySqlDataSource. I set the OnChange event to a subroutine similar to below:

Private Sub FilterDropDownList_Change(s as Object, e as EventArgs)
If FilterDropDownList.SelectedValue = “Filter” then
MySqlDataSource.FilterExpression = “MyColumn=1″
Else
MySqlDataSource.FilterExpression = “”
End If

MyGridView.DataBind
End Sub

I added the sub MyGridView.DataBind to the subroutine because this subroutine occurs after the SqlDataSource object is created and the resultset is filled. In reality, you only need to perform the MyGridView.DataBind when the FilterExpression value is set to something other than “”.

From

http://weblogs.asp.net/jgaylord/archive/2006/05/31/Filter-A-GridView-After-The-Initial-Bind.aspx

Share

Tags: .NET Languages .NET Valley Architecture Design Patterns and Testing ASP.NET ASP.NET and ASP.NET MVC ASP.NET MVC ASP.NET.NET Books Browsers Business Community News Conference Content Management Server , ASP.NET and ASP.NET MVC, General Software Development, Tips and Tricks

This entry was posted on Tuesday, April 13th, 2010 at 2:17 PM and is filed under ASP.NET. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.