Como: Filtrar e classificar dados em um aplicativo do Windows Forms

Artigo
08/01/2011

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.

Observação
If your application does not use BindingSource components, then you can filter and sort data using DataView objects. Para obter mais informações, consulte DataViews (ADO.NET).

Para filtrar dados usando um componente BindingSource

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'";
```

Para classificar dados usando um componente BindingSource

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";
```