Skip to main content
All docs
V25.1
  • DevExpress v25.1 Update — Your Feedback Matters

    Our What's New in v25.1 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

    Take the survey Not interested

    Data Filtering and Search

    • 2 minutes to read

    The GridControl, VGridControl, PivotGridControl, PropertyGridControl, TreeList, GanttControl, and ChartControl allow you to filter and search for data. When you filter data, the control only displays records that meet the applied filter criteria. When you search for data, however, the control only highlights records. Users can utilize the following features to filter and search for data:

    The following comparison table lists features supported by DevExpress data-aware controls.

    Control

    Excel-Style Filter Menus

    Classic Filter Menus

    Auto Filter Row

    Filter Panel & Filter Editor

    Find Panel

    Filter UI Context

    Incremental Search

    Filter in Code

    Conditional Formatting Filters

    GridControl

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    TreeList, GanttControl

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    PivotGridControl

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    yes

    no

    VGridControl

    yes

    no

    no

    yes

    yes

    yes

    no

    yes

    yes

    PropertyGridControl

    no

    no

    no

    no

    yes

    no

    no

    yes

    no

    ChartControl

    no

    no

    no

    no

    no

    yes

    no

    yes

    no

    Tip

    Data controls with similar features expose the same API. For example, to access options specific to Excel-style filter menus, you can use the GridView.OptionsFilter, VGridControl.OptionsFilter, PivotGridControl.OptionsFilter or TreeList.OptionsFilter property.

    #Cheat Sheets and Best Practices

    DevExpress WinForms data-aware UI controls (Data Grid, Tree List, Vertical Grid, Gantt Control, etc.) share the same data filtering techniques. Read the following quick-reference guide for detailed information and examples:

    Filter DevExpress Data-Aware Controls - DevExpress WinForms Cheat Sheet