Typically used in complex data-binding scenarios, the Filter property allows you to view a subset of the DataSource. Only underlying lists that implement the IBindingListView interface support filtering.
When Filter is not nullNothingnullptra null reference (Nothing in Visual Basic), the BindingSource passes this property to the underlying list. If you set this property during object initialization, the call will be deferred until after initialization is complete.
To form a filter value, specify the name of a column followed by an operator and a value to filter on. The accepted filter syntax depends on the underlying data source. If the underlying data source is a DataSet, DataTable, or DataView, you can specify Boolean expressions using the syntax documented for the DataColumn..::.Expression property.
The value of the Filter property will persist when the data source changes. To stop filtering the DataSource, call the RemoveFilter method.