Example of Filter Menu in ASP.NET MVC Data Grid Control

This sample demonstrates the grid's multiple-type filter functionality and user interface.

DEMO

SOURCE

Filter Type

The filtering feature enables the user to view a reduced number of records based on the filter criteria. It can be enabled by setting the AllowFiltering property to true.

The grid supports the following filter types:

FilterBar
Menu
CheckBox
Excel

You can change the filter type by setting FilterSettings->Type.

In this demo, filter menu is enabled by default. You can switch to other filter types using the dropdown.

Additionally, we have an on-demand data fetch functionality and UI for the checkbox/Excel filter type. It can be enabled by setting the filterSettings->enableInfiniteScrollingopens in a new tab property to true. In this demo, on-demand data fetch is not enabled by default. To enable the on-demand data fetch for the checkbox/Excel filter type, the Enable OnDemand option must be checked after selecting the checkBox/Excel filter type using the dropdown menu.

The Grid now supports improved in and not in filter operators, allowing users to filter multiple values within the same column. When the menu filter is enabled, a Syncfusion MultiSelect Dropdown component with checkboxes appears to select the in or not in operators.

More information on the filter configuration can be found in this documentation sectionopens in a new tab.