How to: Apply a Filter to a Column
- 2 minutes to read
Example 1
The following code selects records whose shipping country names start with ‘F’. The required filter is created using a ColumnFilterInfo object. It’s then assigned to the GridColumn.FilterInfo property.
using DevExpress.XtraGrid.Columns;
gridView1.Columns["ShipCountry"].FilterInfo =
new ColumnFilterInfo("[ShipCountry] LIKE 'F%'");
Example 2
The following code shows how to add a filter condition to a View via its ColumnView.ActiveFilter object. The filter condition selects records whose CategoryName fields start with ‘c’.
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Columns;
//...
ColumnView view = gridView1;
view.ActiveFilter.Add(view.Columns["CategoryName"],
new ColumnFilterInfo("[CategoryName] Like 'c%'", ""));
Example 3
The following code shows how to add a filter condition to a View via its ColumnView.ActiveFilter object. The filter condition selects records which contain the values “Produce” or “Seafood” in the CategoryName column.
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Columns;
//...
ColumnView view = gridView1;
ViewColumnFilterInfo viewFilterInfo = new ViewColumnFilterInfo(view.Columns["CategoryName"],
new ColumnFilterInfo("[CategoryName] = 'Produce' OR [CategoryName] = 'Seafood'", ""));
view.ActiveFilter.Add(viewFilterInfo);
Example 4
The following example selects records that contain a null value in the ‘Region’ field.