Skip to main content
All docs
V24.1

Data Filtering and Search

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

GridControl

yes

yes

yes

yes

yes

yes

yes

yes

TreeList, GanttControl

yes

yes

yes

yes

yes

yes

yes

yes

PivotGridControl

yes

yes

yes

yes

yes

yes

yes

yes

VGridControl

yes

no

no

yes

yes

yes

no

yes

PropertyGridControl

no

no

no

no

yes

no

no

yes

ChartControl

no

no

no

no

no

yes

no

yes

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