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:
- Excel-Style Column Filter Menus
- Classic Column Filter Menus
- Auto Filter Row
- Filter Panel
- Filter Editor
- Find Panel (supports filter and search modes)
- Filtering UI Context
- Incremental Search
- Conditional Formatting Filters
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 |
|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
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