gridView1.ActiveFilterString = "[OrderDate] Between (#01 JAN 2010#, #01 DEC 2010#) And [ShipRegion] Is not null";

gridView1.ActiveFilterString = "[OrderDate] Between (#01 JAN 2010#, #01 DEC 2010#) And [ShipRegion] Is not null"

string filterString = "[UnitPrice] > 20 AND [UnitPrice] < 30 AND [InStock] = true";
gridView.Columns["UnitPrice"].FilterInfo = new ColumnFilterInfo(filterString);

Dim filterString As String = "[UnitPrice] > 20 AND [UnitPrice] < 30 AND [InStock] = true"
gridView.Columns("UnitPrice").FilterInfo = New ColumnFilterInfo(filterString)

string filterString = "[ShipCountry] = 'Canada'";
gridView1.Columns["ShipCity"].FilterInfo = new ColumnFilterInfo(filterString);

Dim filterString As String = "[ShipCountry] = 'Canada'"
gridView1.Columns("ShipCity").FilterInfo = New ColumnFilterInfo(filterString)

gridView1.ActiveFilter.NonColumnFilter = "UnitPrice * Quantity >= 50";

gridView1.ActiveFilter.NonColumnFilter = "UnitPrice * Quantity >= 50"

using DevExpress.XtraGrid.Views.Base;

private void gridView1_CustomRowFilter(object sender, RowFilterEventArgs e) {
    ColumnView view = sender as ColumnView;
    string country = view.GetListSourceRowCellValue(e.ListSourceRow, "Country").ToString();
    // Check whether the current row contains "USA" in the "Country" field.
    if (country == "USA") {
        // Make the current row visible.
        e.Visible = true;
        // Prevent default processing, so that the row is visible 
        // regardless of the view's filter.
        e.Handled = true;
    }
}

Imports DevExpress.XtraGrid.Views.Base

Private Sub GridView1_CustomRowFilter(ByVal sender As Object, _
  ByVal e As DevExpress.XtraGrid.Views.Base.RowFilterEventArgs) _
  Handles GridView1.CustomRowFilter
   Dim view As ColumnView = CType(sender, ColumnView)
   Dim country As String = view.GetListSourceRowCellValue(e.ListSourceRow, "Country").ToString()
   ' Check whether the current row contains "USA" in the "Country" field.
   If country = "USA" Then
      ' Make the current row visible.
      e.Visible = True
      ' Prevent default processing, so that the row is visible
      ' regardless of the view's filter.
      e.Handled = True
   End If
End Sub

using DevExpress.Data.Filtering;
using DevExpress.Data;

private void Form1_Load(object sender, EventArgs e) {
    DataSet ds = new DataSet();
    ds.ReadXml("nwind.xml");
    this.GridControl.DataSource = ds;
    this.GridControl.DataMember = "Orders";
    this.GridView.ActiveFilterCriteria = CriteriaOperator.Parse("Freight > 0");
}

private void GridView_SubstituteFilter(object sender, SubstituteFilterEventArgs e) {
    e.Filter &= CriteriaOperator.Parse("getyear(OrderDate) = ?", Convert.ToInt32(this.beiShowByYear.EditValue));
}

private void beiShowByYear_EditValueChanged(object sender, EventArgs e) {
    CriteriaOperator filter = this.GridView.ActiveFilterCriteria;
    this.GridView.BeginDataUpdate();
    try {
        this.GridView.ActiveFilterCriteria = null;
        this.GridView.ActiveFilterCriteria = filter;
    } finally {
        this.GridView.EndDataUpdate();
    }
}

Imports DevExpress.Data.Filtering
Imports DevExpress.Data

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load
    Dim ds As New DataSet()
    ds.ReadXml("nwind.xml")
    Me.GridControl.DataSource = ds
    Me.GridControl.DataMember = "Orders"
    Me.GridView.ActiveFilterCriteria = CriteriaOperator.Parse("Freight > 0")
End Sub

Private Sub GridView_SubstituteFilter(ByVal sender As Object, ByVal e As SubstituteFilterEventArgs) Handles GridView.SubstituteFilter
    e.Filter = e.Filter And CriteriaOperator.Parse("getyear(OrderDate) = ?", Convert.ToInt32(Me.beiShowByYear.EditValue))
End Sub

Private Sub beiShowByYear_EditValueChanged(ByVal sender As Object, ByVal e As EventArgs) Handles beiShowByYear.EditValueChanged
    Dim filter As CriteriaOperator = Me.GridView.ActiveFilterCriteria
    Me.GridView.BeginDataUpdate()
    Try
        Me.GridView.ActiveFilterCriteria = Nothing
        Me.GridView.ActiveFilterCriteria = filter
    Finally
        Me.GridView.EndDataUpdate()
    End Try
End Sub

// Customizes the drop-down menu for one specific Data Grid
void gridView1_ShowFilterPopupExcel(object sender, FilterPopupExcelEventArgs e) {
    e.ShowNulls = false;
}
// Customizes the drop-down menu for all Data Grid controls within an application
DevExpress.Utils.Filtering.ExcelFilterOptions.Default.ShowNulls = false;

' Customizes the drop-down menu for one specific Data Grid
Private Sub gridView1_ShowFilterPopupExcel(ByVal sender As Object, ByVal e As FilterPopupExcelEventArgs)
    e.ShowNulls = False
End Sub
' Customizes the drop-down menu for all Data Grid controls within an application
DevExpress.Utils.Filtering.ExcelFilterOptions.Default.ShowNulls = False

void gridView_FilterPopupExcelData(object sender, Views.Grid.FilterPopupExcelDataEventArgs e) {
    if(e.Column == bcModification) {
        e.AddFilter("Automatic Transmission (6-speed)", "Contains([" + e.Column.FieldName + "], '6A')");
        e.AddFilter("Automatic Transmission (8-speed)", "Contains([" + e.Column.FieldName + "], '8A')");
        e.AddFilter("Manual Transmission (6-speed)", "Contains([" + e.Column.FieldName + "], '6M')");
        e.AddFilter("Manual Transmission (7-speed)", "Contains([" + e.Column.FieldName + "], '7M')");
        e.AddFilter("Variomatic Transmission", "Contains([" + e.Column.FieldName + "], 'VA')");
        e.AddFilter("Limited Edition", "Contains([" + e.Column.FieldName + "], 'Limited')");
    }
    if(e.Column == bcMPGCity) {
        e.AddFilter("Fuel Economy (High)", "[" + e.Column.FieldName + "]<=15");
        e.AddFilter("Fuel Economy (Medium)", "[" + e.Column.FieldName + "]>15 AND [" + e.Column.FieldName + "]<25");
        e.AddFilter("Fuel Economy (Low)", "[" + e.Column.FieldName + "]>=25");
    }
}

Private Sub gridView_FilterPopupExcelData(ByVal sender As Object, ByVal e As Views.Grid.FilterPopupExcelDataEventArgs) Handles bandedGridView1.FilterPopupExcelData
    If e.Column Is bcModification Then
        e.AddFilter("Automatic Transmission (6-speed)", "Contains([" & e.Column.FieldName & "], '6A')")
        e.AddFilter("Automatic Transmission (8-speed)", "Contains([" & e.Column.FieldName & "], '8A')")
        e.AddFilter("Manual Transmission (6-speed)", "Contains([" & e.Column.FieldName & "], '6M')")
        e.AddFilter("Manual Transmission (7-speed)", "Contains([" & e.Column.FieldName & "], '7M')")
        e.AddFilter("Variomatic Transmission", "Contains([" & e.Column.FieldName & "], 'VA')")
        e.AddFilter("Limited Edition", "Contains([" & e.Column.FieldName & "], 'Limited')")
    End If
    If e.Column Is bcMPGCity Then
        e.AddFilter("Fuel Economy (High)", "[" & e.Column.FieldName & "]<=15")
        e.AddFilter("Fuel Economy (Medium)", "[" & e.Column.FieldName & "]>15 AND [" & e.Column.FieldName & "]<25")
        e.AddFilter("Fuel Economy (Low)", "[" & e.Column.FieldName & "]>=25")
    End If
End Sub

using DevExpress.Data.Filtering;

IsBlackFridayDiscountFunction.Register();
gridView1.QueryCustomFunctions += OnQueryCustomFunctions;

void OnQueryCustomFunctions(object sender, CustomFunctionEventArgs e) {
    if(e.PropertyName == "Discount")
        e.Add(IsBlackFridayDiscountFunction.FunctionName);
}

public class IsBlackFridayDiscountFunction : ICustomFunctionDisplayAttributes {
    // See the QueryCustomFunctions event for the complete implementation.
}

Imports DevExpress.Data.Filtering

IsBlackFridayDiscountFunction.Register()
AddHandler gridView1.QueryCustomFunctions, AddressOf OnQueryCustomFunctions

Private Sub OnQueryCustomFunctions(ByVal sender As Object, ByVal e As Data.Filtering.CustomFunctionEventArgs)
    If e.PropertyName = "Discount" Then
        e.Add(IsBlackFridayDiscountFunction.FunctionName)
    End If
End Sub

Public Class IsBlackFridayDiscountFunction
    Implements ICustomFunctionDisplayAttributes
    ' See the QueryCustomFunctions event for the complete implementation.
End Class

private void gridView_CustomFilterDialog(object sender, DevExpress.XtraGrid.Views.Grid.CustomFilterDialogEventArgs e) {
    if (e.Column.FieldName != "UnitPrice") return;
    string filterSting = "[UnitPrice] > 10 AND [UnitPrice] < 30";
    string displayText = "[UnitPrice] > $10.00 AND [UnitPrice] < $30.00";
    ColumnFilterInfo columnFilter = new ColumnFilterInfo(filterSting, displayText);
    e.FilterInfo = columnFilter;
    e.Handled = true;
}

Private Sub gridView_CustomFilterDialog(ByVal sender As Object, ByVal e As DevExpress.XtraGrid.Views.Grid.CustomFilterDialogEventArgs)
    If e.Column.FieldName <> "UnitPrice" Then
        Return
    End If
    Dim filterSting As String = "[UnitPrice] > 10 AND [UnitPrice] < 30"
    Dim displayText As String = "[UnitPrice] > $10.00 AND [UnitPrice] < $30.00"
    Dim columnFilter As New ColumnFilterInfo(filterSting, displayText)
    e.FilterInfo = columnFilter
    e.Handled = True
End Sub

private void gridView_ShowFilterPopupListBox(object sender, FilterPopupListBoxEventArgs e) {
    if (e.Column.FieldName != "Priority") return;
    // Get the first value item's index. 
    int index;
    for (index = 0; index < e.ComboBox.Items.Count; index++) {
        object item = e.ComboBox.Items[index];
        if (item is FilterItem) {
            object itemValue = ((FilterItem)item).Value;
            if (itemValue is FilterItem || itemValue is ColumnFilterInfo) continue;
            break;
        }
    }
    // Create a filter criterion to select records with the "High" and "Medium" priorities. 
    string filterString = "([Priority] == 3 OR [Priority] == 2)";
    string filterDisplayText = "[Priority] == High OR [Priority] == Medium";
    ColumnFilterInfo filterInfo = new ColumnFilterInfo(filterString, filterDisplayText);
    e.ComboBox.Items.Insert(index, new FilterItem("Important", filterInfo));
}

Private Sub gridView_ShowFilterPopupListBox(ByVal sender As Object, ByVal e As FilterPopupListBoxEventArgs)
    If e.Column.FieldName <> "Priority" Then
        Return
    End If
    ' Get the index of the first value item. 
    Dim index As Integer
    For index = 0 To e.ComboBox.Items.Count - 1
        Dim item As Object = e.ComboBox.Items(index)
        If TypeOf item Is FilterItem Then
            Dim itemValue As Object = DirectCast(item, FilterItem).Value
            If TypeOf itemValue Is FilterItem OrElse TypeOf itemValue Is ColumnFilterInfo Then
                Continue For
            End If
            Exit For
        End If
    Next index
    ' Create a filter criterion to select records with the "High" and "Medium" priorities. 
    Dim filterString As String = "([Priority] == 3 OR [Priority] == 2)"
    Dim filterDisplayText As String = "[Priority] == High OR [Priority] == Medium"
    Dim filterInfo As New ColumnFilterInfo(filterString, filterDisplayText)
    e.ComboBox.Items.Insert(index, New FilterItem("Important", filterInfo))
End Sub

private void gridView_ShowFilterPopupCheckedListBox(object sender, FilterPopupCheckedListBoxEventArgs e) {
    if (e.Column.FieldName != "Name") return;
    for (int i = 0; i < e.CheckedComboBox.Items.Count; i++) {
        CheckedListBoxItem item = e.CheckedComboBox.Items[i];
        string itemValue = (string)(item.Value as FilterItem).Value;
        // Disable checked items that start with "Data".  
        if (itemValue.StartsWith("Data"))
            e.CheckedComboBox.Items[i].Enabled = false;
        // Remove checked items that start with "Help".  
        if (itemValue.StartsWith("Help")) {
            e.CheckedComboBox.Items.Remove(item);
            i--;
        }
    }
}

Private Sub gridView_ShowFilterPopupCheckedListBox(ByVal sender As Object, ByVal e As FilterPopupCheckedListBoxEventArgs)
    If e.Column.FieldName <> "Name" Then
        Return
    End If
    Dim i As Integer = 0
    Do While i < e.CheckedComboBox.Items.Count
        Dim item As CheckedListBoxItem = e.CheckedComboBox.Items(i)
        Dim itemValue As String = CStr((TryCast(item.Value, FilterItem)).Value)
        ' Disable checked items that start with "Data".  
        If itemValue.StartsWith("Data") Then
            e.CheckedComboBox.Items(i).Enabled = False
        End If
        ' Remove checked items that start with "Help".  
        If itemValue.StartsWith("Help") Then
            e.CheckedComboBox.Items.Remove(item)
            i -= 1
        End If
        i += 1
    Loop
End Sub

private void gridView1_ShowFilterPopupDate(object sender, FilterPopupDateEventArgs e) {
    if(e.Column.FieldName != "Date") return;
    e.List.Clear();
    DateTime firstDayOfThisYear = new DateTime(DateTime.Today.Year, 1, 1);
    DateTime firstDayOfLastYear = firstDayOfThisYear.AddYears(-1);

    CriteriaOperator lastYear = new BinaryOperator(
        e.Column.FieldName, firstDayOfLastYear, BinaryOperatorType.GreaterOrEqual);
    CriteriaOperator thisYear = new BinaryOperator(
        e.Column.FieldName, firstDayOfThisYear, BinaryOperatorType.Less);
    CriteriaOperator crit = new GroupOperator(GroupOperatorType.And, lastYear, thisYear);

    e.List.Add(new DevExpress.XtraEditors.FilterDateElement("Last Year", "", crit));
}

Private Sub gridView1_ShowFilterPopupDate(ByVal sender As Object, ByVal e As FilterPopupDateEventArgs)
    If e.Column.FieldName <> "Date" Then
        Return
    End If
    e.List.Clear()
    Dim firstDayOfThisYear As New Date(Date.Today.Year, 1, 1)
    Dim firstDayOfLastYear As Date = firstDayOfThisYear.AddYears(-1)

    Dim lastYear As CriteriaOperator = New BinaryOperator(e.Column.FieldName, firstDayOfLastYear, BinaryOperatorType.GreaterOrEqual)
    Dim thisYear As CriteriaOperator = New BinaryOperator(e.Column.FieldName, firstDayOfThisYear, BinaryOperatorType.Less)
    Dim crit As CriteriaOperator = New GroupOperator(GroupOperatorType.And, lastYear, thisYear)

    e.List.Add(New DevExpress.XtraEditors.FilterDateElement("Last Year", "", crit))
End Sub

using DevExpress.Utils.Filtering;
public class Customer {
    [FilterLookup]
    public Int32 ID { get; set; }
    //. . .
}

Imports DevExpress.Utils.Filtering
Public Class Customer
    <FilterLookup>
    Public Property ID() As Int32
    '. . .
End Class

// Find rows by cell value
private void btn_LocateRow_ItemClick(object sender, ItemClickEventArgs e) {
    int rowHandle = gridView.LocateByValue(gridView.FocusedRowHandle + 1, gridView.Columns["Category"], 1);
    gridView.FocusedRowHandle = rowHandle;
}

// Find rows by cell display text
private void btn_LocateRow_ItemClick(object sender, ItemClickEventArgs e) {
    int rowHandle = gridView.LocateByDisplayText(gridView.FocusedRowHandle + 1, gridView.Columns["Category"], "Beverages");
    gridView.FocusedRowHandle = rowHandle;
}

' Find rows by cell value
Private Sub btn_LocateRow_ItemClick(ByVal sender As Object, ByVal e As ItemClickEventArgs)
    Dim rowHandle As Integer = gridView.LocateByValue(gridView.FocusedRowHandle + 1, gridView.Columns("Category"), 1)
    gridView.FocusedRowHandle = rowHandle
End Sub

' Find rows by cell display text
Private Sub btn_LocateRow_ItemClick(ByVal sender As Object, ByVal e As ItemClickEventArgs)
    Dim rowHandle As Integer = gridView.LocateByDisplayText(gridView.FocusedRowHandle + 1, gridView.Columns("Category"), "Beverages")
    gridView.FocusedRowHandle = rowHandle
End Sub

// Customize the Trademark column's filter menu. 
bcTrademark.OptionsFilter.PopupExcelFilterGrouping = "Trademark;Name";
// The customized column's values are displayed at the root level by default; you can omit its name ("Trademark"). 
// The code below has the same effect. 
bcTrademark.OptionsFilter.PopupExcelFilterGrouping = "Name";

' Customize the Trademark column's filter menu. 
bcTrademark.OptionsFilter.PopupExcelFilterGrouping = "Trademark;Name"
' The customized column's values are displayed at the root level; you can omit its name ("Trademark"). 
' The code below has the same effect. 
bcTrademark.OptionsFilter.PopupExcelFilterGrouping = "Name"

// Customize the Name column's filter menu. 
// The customized column's values are displayed at the root level. You can omit its name ("Trademark").
bcName.OptionsFilter.PopupExcelFilterGrouping = "Trademark;Name";

' Customize the Name column's filter menu. 
' The customized column's values are displayed at the root level. You can omit its name ("Trademark").
bcName.OptionsFilter.PopupExcelFilterGrouping = "Trademark;Name"

[Utils.Filtering.FilterGroup("Trademark;Name")]
public string Name { get; set; }
public string Trademark { get; set; }

<Utils.Filtering.FilterGroup("Trademark;Name")>
Public Property Name As String
Public Property Trademark As String

public partial class Form1 : DevExpress.XtraEditors.XtraForm {
    public Form1() {
        InitializeComponent();
        gridControl1.DataSource = Order.InitData();
    }
}

public class Order {
    public string Name { get; set; }
    public double Price { get; set; }
    public DateTime CreateDate { get; set; }
    public bool Delivered { get; set; }
    static public List<Order> InitData() {
        return new List<Order>() {
            new Order(){ Name = "Order A", Price = 19.99, CreateDate = DateTime.Now, Delivered = false},
            new Order(){ Name = "Order B", Price = 149.99, CreateDate = new DateTime(2022, 10, 10), Delivered = true},
            new Order(){ Name = "Order C", Price = 52.99, CreateDate = DateTime.Now, Delivered = false},
            new Order(){ Name = "Order D", Price = 87.99, CreateDate = new DateTime(2022, 5, 1), Delivered = true}
        };
    }
}

Partial Public Class Form1
    Inherits DevExpress.XtraEditors.XtraForm

    Public Sub New()
        InitializeComponent()
        gridControl1.DataSource = Order.InitData()
    End Sub
End Class

Public Class Order
    Public Property Name() As String
    Public Property Price() As Double
    Public Property CreateDate() As Date
    Public Property Delivered() As Boolean
    Public Shared Function InitData() As List(Of Order)
        Return New List(Of Order)() From {
            New Order() With {.Name = "Order A", .Price = 19.99, .CreateDate = Date.Now, .Delivered = False},
            New Order() With {.Name = "Order B", .Price = 149.99, .CreateDate = New Date(2022, 10, 10), .Delivered = True},
            New Order() With {.Name = "Order C", .Price = 52.99, .CreateDate = Date.Now, .Delivered = False},
            New Order() With {.Name = "Order D", .Price = 87.99, .CreateDate = New Date(2022, 5, 1), .Delivered = True}
        }
    End Function
End Class

public Form1() {
    InitializeComponent();
    // Bind the Grid to data.
    gridControl1.DataSource = Order.InitData();
    // Forces the Grid to initialize its settings.
    gridControl1.ForceInitialize();
    // Create a repository item to display and edit numeric values.
    RepositoryItemSpinEdit priceEdit = new RepositoryItemSpinEdit() { Name = "priceEdit" };
    // Specifies the display format.
    priceEdit.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
    priceEdit.DisplayFormat.FormatString = "c2";
    // Sets the mask expression.
    priceEdit.MaskSettings.MaskExpression = "c2";
    // Adds the repository item to the Grid's RepositoryItems collection.
    gridControl1.RepositoryItems.Add(priceEdit);
    // Assigns the repository item to the 'Price' column.
    gridView1.Columns["Price"].ColumnEdit = priceEdit;
}

Public Sub New()
    InitializeComponent()
    ' Bind the Grid to data.
    gridControl1.DataSource = Order.InitData()
    ' Forces the Grid to initialize its settings.
    gridControl1.ForceInitialize()
    ' Create a repository item to display and edit numeric values.
    Dim priceEdit As New RepositoryItemSpinEdit() With {.Name = "priceEdit"}
    ' Specifies the display format.
    priceEdit.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric
    priceEdit.DisplayFormat.FormatString = "c2"
    ' Sets the mask expression.
    priceEdit.MaskSettings.MaskExpression = "c2"
    ' Adds the repository item to the Grid's RepositoryItems collection.
    gridControl1.RepositoryItems.Add(priceEdit)
    ' Assigns the repository item to the 'Price' column.
    gridView1.Columns("Price").ColumnEdit = priceEdit
End Sub

private void showActiveCustomersBtn_Click(object sender, EventArgs e) {
    gridView.ActiveFilterString = "IsActive = true";
}

Private Sub showActiveCustomersBtn_Click(ByVal sender As Object, ByVal e As EventArgs) Handles showActiveCustomersBtn.Click
    gridView.ActiveFilterString = "IsActive = true"
End Sub

private void GridView_CustomRowFilter(object sender, DevExpress.XtraGrid.Views.Base.RowFilterEventArgs e) {
    GridView view = sender as GridView;
    bool isCustomerActive = (bool)view.GetListSourceRowCellValue(e.ListSourceRow, "IsActive");
    e.Visible = isCustomerActive;
    e.Handled = true;
}

Private Sub GridView_CustomRowFilter(ByVal sender As Object, ByVal e As DevExpress.XtraGrid.Views.Base.RowFilterEventArgs)
    Dim view As GridView = TryCast(sender, GridView)
    Dim isCustomerActive As Boolean = DirectCast(view.GetListSourceRowCellValue(e.ListSourceRow, "IsActive"), Boolean)
    e.Visible = isCustomerActive
    e.Handled = True
End Sub

gridView.ActiveFilterString = "Contains([Name], 'Blue')";

btnObtainFilteredRows.Click += (s, e) => {
    List<SampleData> filteredRows = new List<SampleData>();
    // Traverse through all currently visible rows within GridView
    for(int i = 0; i < gridView.RowCount; i++) {
        // Obtain the processed row object
        SampleData row = (SampleData)gridView.GetRow(i); 
        filteredRows.Add(row);
    }
    XtraMessageBox.Show(string.Format("Filtered rows: {0}", filteredRows.Count));
};

gridView.ActiveFilterString = "Contains([Name], 'Blue')"

AddHandler btnObtainFilteredRows.Click, Sub(s, e)
    Dim filteredRows As New List(Of SampleData)()
    ' Traverse through all currently visible rows within GridView
    For i As Integer = 0 To gridView.RowCount - 1 
    ' Obtain the processed row object
        Dim row As SampleData = CType(gridView.GetRow(i), SampleData) 
        filteredRows.Add(row)
    Next i
    XtraMessageBox.Show(String.Format("Filtered rows: {0}", filteredRows.Count))
End Sub