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.
Set the Filter property to the expression you want to return. For example, the following code returns customers with a
CompanyNamethat starts with "B":
Set the Sort property to the column you want to sort on. For example, the following code sorts customers on the
CompanyNamecolumn in descending order: