Filtering in Code

Feb 02, 2023

The DevExpress ASP.NET MVC Grid View extension allows you to filter its data programmatically using one of the following methods:

The ASPxClientGridView.AutoFilterByColumn method.
The ASPxGridView.AutoFilterByColumn method.
The GridViewDataColumn.AutoFilterBy method.
The MVCxGridView.FilterExpression property allows you to provide complex filter criteria.

Example

The following code illustrates how to filter grid records by Country “USA” and Unit Price greater than “250”:

Razor

cshtml

@Html.DevExpress().GridView(settings => {
    settings.Name = "gridView";
    settings.FilterExpression="[Country] = 'USA' AND [UnitPrice] > 250";
...
}).Bind(Model).GetHtml()