Radzen Professional is now 20% off until January 4th 2019! Learn more

Default filter value for DataGrid column

This guide demonstrates how to set default filter value for DataGrid column.

Source Code

Step by step

1. Create new application with .NET server-side project and add new MSSQL data-source connected to Northwind database.

2. Create new Orders page and bind DataGrid to Orders table.

3. Add new Page property defaultOrderID, define $filter parameter for Northwind.getOrders method invoke on Page load event, define $filter parameter ${event.filter ? event.filter + ' and ':''}OrderID eq ${defaultOrderID} for Northwind.getOrders method invoke on DataGrid LoadData and bind DataGrid OrderID column to defaultOrderID.

4. Set defaultOrderID to this.grid0.columns.first.filterValue in DataGrid LoadData event and define $filter parameter ${event.filter ? event.filter + ' and ':''}${this.defaultOrderID ? 'OrderID eq ' + this.defaultOrderID : ''} for Northwind.getOrders method invoke on DataGrid LoadData.

5. Run the application

We are here for you

Making our users happy is always a priority for us.