Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Header Filter

Company Name Not filtered
Country Not filtered
City Not filtered
Unit Price Not filtered
Quantity Not filtered
Discount Not filtered
Total Not filtered
Alfreds FutterkisteGermanyBerlin$13.25405%$503.50
Alfreds FutterkisteGermanyBerlin$21.50200%$430.00
Alfreds FutterkisteGermanyBerlin$43.90200%$878.00
Alfreds FutterkisteGermanyBerlin$10.0060%$60.00
Alfreds FutterkisteGermanyBerlin$18.00150%$270.00
Alfreds FutterkisteGermanyBerlin$45.601525%$513.00
Alfreds FutterkisteGermanyBerlin$18.002125%$283.50
Alfreds FutterkisteGermanyBerlin$12.00225%$18.00
Alfreds FutterkisteGermanyBerlin$55.00150%$825.00
Alfreds FutterkisteGermanyBerlin$13.00220%$20.80
Count=2,155     Sum=$1,265,793.04
Page 1 of 216 (2155 items)Prev1234567214215216Next

The Grid View control implements a column header filter that displays a dropdown list of all unique values within a column. Set the ShowHeaderFilterButton to true to show header filter buttons for each data column. You can use the AllowHeaderFilter property to control the button visibility for a particular data column.

Users can enter text in the filter editor above the list to filter list items. To hide the filter editor, set the ShowHeaderFilterListBoxSearchUI property to false.

A column’s Mode property specifies the filter mode. You can set the following filter modes for each grid data column.

  • List – the dropdown window displays a regular list of items that allows users to select a single value.
  • CheckedList – the dropdown window displays a check box list that allows users to select multiple values.

Additionally, the grid control implements filter modes for specific column data types: DateRangeCalendar and DateRangePicker modes available for date columns; NumericRangePicker mode available for numeric columns. You can try these modes in the Range Header Filter demo.

You can handle the following events to customize the header filter items:

In this demo, the header filters of the Total and Quantity columns contain custom items.

Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos