ContextQMD
Back to Devexpress

How to: Apply a Filter to a View

windowsforms-3012-controls-and-libraries-data-grid-examples-filtering-how-to-apply-a-filter-to-a-view.md

latest1.6 KB
Original Source

How to: Apply a Filter to a View

  • Nov 13, 2018

Example 1

This example demonstrates how to assign a filter to a View using the ColumnView.ActiveFilterString property.

csharp
gridView1.ActiveFilterString = "([ProductID] = 1 OR [ProductID] = 3 " + 
  "OR [ProductID] > 10) AND [Discount] = 0";
vb
GridView1.ActiveFilterString = "([ProductID] = 1 OR [ProductID] = 3 " & _
  "OR [ProductID] > 10) AND [Discount] = 0"

Example 2

The following code demonstrates how to create the following filter criteria via the ColumnView.ActiveFilterCriteria property, using the GroupOperator and BinaryOperator objects:

“[Extension] = ‘.gif’ OR [Extension] = ‘.png’”

csharp
using DevExpress.Data.Filtering;

CriteriaOperator expr1 = new BinaryOperator("Extension", ".gif");
CriteriaOperator expr2 = new BinaryOperator("Extension", ".png");
gridView1.ActiveFilterCriteria = GroupOperator.Or(new CriteriaOperator[] { expr1, expr2 });
vb
Imports DevExpress.Data.Filtering

Dim expr1 As CriteriaOperator = New BinaryOperator("Extension", ".gif")
Dim expr2 As CriteriaOperator = New BinaryOperator("Extension", ".png")
gridView1.ActiveFilterCriteria = GroupOperator.Or(New CriteriaOperator() {expr1, expr2})