The DevExpress ASP.NET Grid View (ASPxGridView) provides a powerful data filtering mechanism that displays a dropdown list of all unique values within a column. Invoked by activating the column header’s filter button, end-users can filter the records stored in the underlying dataset by selecting the values displayed within the dropdown.
Additionally, end-users can filter items by entering text in the filter editor above the list. When typing a filter string, the header filter items list is automatically updated, so only the relevant items that match the filter string are displayed.
Filter dropdown buttons are disabled by default. To show filter buttons, set the Settings.ShowHeaderFilterButton property to true.
You can specify the header filter mode for a column using the SettingsHeaderFilter.Mode property.
- In List mode, the column's header filter dropdown displays a regular list of filter items, allowing end-users to select single value.
- In CheckedList mode, the column's header filter dropdown contains a check box list, allowing end-users to select multiple values for the filter criteria.
- DateRangeCalendar and DateRangePicker modes are available for date columns only. You can take a look at these modes in the Date Range Header Filter demo.
The ASPxGridView allows you to create custom filter values, define filter criteria and display these values within the column's filter dropdown. To do this, handle the HeaderFilterFillItems event. In this demo, custom filter values are displayed within the 'Total' and 'Quantity' columns' filter dropdowns.