How to: Filter and Sort Data in a Windows Forms Application
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.
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":
CustomersBindingSource.Filter = "CompanyName like 'B'"
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:
CustomersBindingSource.Sort = "CompanyName Desc"
customersBindingSource.Sort = "CompanyName Desc";