How to: Filter and Sort Data

MSDN Home

MSDN
MSDN Library
Development Tools and Language ...
Visual Studio 2008
Visual Studio
.NET Framework Programming in ...
Accessing Data
Creating Client Data Applicati ...
Displaying Data on Forms in Wi ...

Switch View :

Classic

Lightweight Beta

ScriptFree

Feedback

Data Access in Client and Middle-Tier Programming

How to: Filter and Sort Data

You filter data by setting the Filter property to a string expression that returns the desired records.

You sort data by setting the Sort property to the column name you want to sort on; append DESC to sort in descending order, or append ASC to sort in ascending order.

Note:
If your application does not use BindingSource components, then you can filter and sort data using DataView objects. For more information, see DataViews (ADO.NET).

To filter data using a BindingSource component

Set the Filter property to the expression you want to return. For example, the following code returns customers with a CompanyName that starts with "B":
Visual Basic
CustomersBindingSource.Filter = "CompanyName like 'B'"
C#
customersBindingSource.Filter = "CompanyName like 'B'";

To sort data using a BindingSource component

Set the Sort property to the column you want to sort on. For example, the following code sorts customers on the CompanyName column in descending order:
Visual Basic
CustomersBindingSource.Sort = "CompanyName Desc"
C#
customersBindingSource.Sort = "CompanyName Desc";