Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [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]Grouping
   [Expand]Sorting
   [Expand]Summaries
   [Expand]Data Editing
   [Collapse]Filtering and Locating Rows
    [Collapse]Filtering
     [Collapse]Filter Dropdowns
       Filter Dropdown: Excel Style
       Filter Dropdown: Regular
       Filter Dropdown: Checked
       Filter Dropdown: Calendar Style
     [Expand]Tutorials
      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]Hints
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [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]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Filter Dropdown: Checked

For columns that display numeric and string values, the filter dropdown is presented in the regular or Excel-inspired style depending on the global and View's settings by default. In the regular mode, only one filter item can be selected at one time. Enable the checked filter dropdown mode to allow multiple filter items to be selected simultaneously. To learn about other types of filter dropdowns, refer to the Filter Dropdowns topic.

Expanded Checked Filter Dropdown Lists

The Filter Dropdown style for a particular column is inherited from the WindowsFormsSettings.ColumnFilterPopupMode global setting, and the View's ColumnViewOptionsFilter.ColumnFilterPopupMode setting, by default. To convert the default Filter Dropdown style to the checked style for a particular column, set the column's OptionsColumnFilter.FilterPopupMode property (accessible from the GridColumn.OptionsFilter object) to CheckedList.

A checked Filter Dropdown list displays unique column values with check boxes on the left side, allowing an end-user to select multiple items simultaneously.

Features supported by the checked filter dropdowns include:

Item Description Related API
Multiple filter values can be selected simultaneously. Selecting a single item applies the following filter to the column:

[ColumnFieldName]=Value

Selecting two items combines filters by the OR operator.

[ColumnFieldName]=Value1 Or [ColumnFieldName]=Value2

When three or more items are selected, the In (Is Any Of) function is used, which is based on the Or operator.

[ColumnFieldName] In (Value1, Value2, Value3)

(Select All) item Selects all items, or cancels filtering against the current column.
(Blanks) item Allows for the filtering of records that contain Null and DBNull values and empty strings.

When checked, the following condition is added to the filter:

IsNullOrEmpty([ColumnFieldName])

List customization You can handle a dedicated event to delete or disable certain items.

Expanded Invoke Filter Dropdown

An end-user can invoke the filter dropdown by clicking the column's filter button. To open the column's filter dropdown in code, call the ColumnView.ShowFilterPopup method.

Expanded Example: Customize a Checked Filter Dropdown

The following example shows how to customize the checked filter dropdown list via the ColumnView.ShowFilterPopupCheckedListBox event. In the example, the filter dropdown is represented as a checked list for a Category Name column. In the ShowFilterPopupCheckedListBox event, the list's "(Select All)" item is hidden, and two check items ("Seafood" and "Condiments") are disabled. The result is shown in the image below:

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