Log In
[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Grid View
   [Expand]View Technology
   [Expand]Data Editing
   [Collapse]Filtering and Locating Rows
     [Expand]Filter Dropdowns
      Filtering Overview
      Filter Settings
      MRU Filters
      Automatic Filtering Row
      Filter Editor
      Custom Filter Dialog
      Filtering in Code
     Locating Rows in Code
     Incremental Search
     Searching via Find Panel
     Tutorial: Incremental Search
     Tutorial: Search/Find Panel
   [Expand]Focus and Selection Handling
   [Expand]Processing Rows
   [Expand]Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
   [Expand]Batch Modifications
   [Expand]Hit Information
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Automatic Filtering Row

The automatic filtering row allows end-users to filter Data Grid records on-the-fly, without invoking the Filter Editor dialog. This row is displayed above regular Grid rows.

Each cell of the automatic filtering row displays two elements.

  • A selector, using which end-users can select a required filter condition. The set of conditions available for a column depends on the type of data this column displays.
  • An editor that allows end-users to enter a value against which column data will be filtered.

The following animation illustrates how end-users can work with the auto-filter row.

Expanded API

The table below enumerates public API related to the automatic filtering row.

GridOptionsFilter.AllowAutoFilterConditionChange Specifies whether or not the auto-filtering row's condition selector is visible.
OptionsColumnFilter.AutoFilterCondition Specifies the filter criteria operator for this column ("Equals", "Like", "Greater", etc.).
OptionsColumnFilter.ImmediateUpdateAutoFilter If this setting is enabled, Data Grid will filter its records immediately as end-users modify the filter condition. Otherwise, filtering will not be applied until a user presses the Enter key or moves focus to another cell.
GridView.ShowAutoFilterConditionsMenu Call this method from code to invoke the automatic filtering row popup menu for the specific column.
Methods that allow you to retrieve the currently applied auto-filtering row condition and apply a new one from code.
GridView.ResetAutoFilterConditions Clears all data filtering applied through the automatic filtering row.

To modify items within a filter condition selector menu, handle the GridView.PopupMenuShowing event. The code below illustrates how to change the condition text from "Is greater than" to "After this date" for all DateTime columns.

Expanded Automatic Filtering Row Without the Condition Selector

Prior to version 17.1, the automatic filtering row had no condition selector. You can switch back to this type of automatic filtering by disabling the GridOptionsFilter.AllowAutoFilterConditionChange or WindowsFormsSettings.AllowAutoFilterConditionChange properties. Alternatively, you can set the WindowsFormsSettings.DefaultSettingsCompatibilityMode property to the v16 value.

For columns that utilize CheckEdit, LookUpEdit and ImageComboBoxEdit in-place editors, filtering values will be compared with cell values using the "Equals" operator. For other columns, the "Like" operator is applied.

Expanded See Also

How would you rate this topic?​​​​​​​