Accessing data has evolved in ASP.NET to include new controls such as the SqlDataSource control. The SqlDataSource class provides a FilterExpression property that can be used to filter the results of calling the SqlDataSource class' Select method.

Click the link above to download ASP source code and Visual Basic source code in a Microsoft Visual Studio 2005 ASP.NET 2.0 solution which demonstrates how to use the SqlDataSource FilterExpression property to filter the rows displayed in an ASP.NET 2.0 GridView.

For more information visit the SqlDataSource and FilterExpression articles on Microsoft's MSDN2 web site.

Get Dot Net Code is a web site full of free and pay for use Visual Basic source code for Visual Basic programmers.