Filter Vertical Grid Data in Code

• Jul 15, 2021

To apply a filter to ASPxVerticalGrid, specify the filter expression and assign it to the ASPxGridBase.FilterExpression property that allows you to provide complex filter criteria (filter data by multiple rows).

C#

VerticalGrid.FilterExpression = "[Country] = 'USA' AND [Quantity] < 15";
VerticalGrid.SettingsText.Title = VerticalGrid.FilterExpression;
//...
//An example on how to filter by dates
DateTime date1 = new DateTime(1996, 12, 1);
DateTime date2 = new DateTime(1996, 12, 31);
string filter = String.Format("[OrderDate] > #{0}# And [OrderDate] < #{1}#", date1.ToShortDateString(), date2.ToShortDateString());
VerticalGrid.FilterExpression = filter;

Setting the ASPxGridBase.FilterExpression property to an empty string clears the filter expression applied to the ASPxVerticalGrid.

C#

ASPxVerticalGridView1.FilterExpression = String.Empty;