Enable EnableRangeFiltering With Programmatic Client Side Binding

[Roberto]

I'm using https://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/programmatic/defaultvb.aspx?show-source=true as an example for client side binding, however for columns with datetime data type I can't get the filter to work properly when EnableRangeFiltering is enabled. Does anyone have an example to make the BuildParameter correct, in which case GridKnownFunction.Between is used and the values are passed in expression.FieldValue separated by space. Example: "01/01/2021 07/01/2021". Thanks

[Attila Antal]

Hi Roberto,

To get the best out of RadGrid, we recommend binding data to it using the RadClientDataSource. (you can download the attached Sample project and test it right away)

Configuration Specifics

Creating the data source for the Grid would have a Field of type DateTime.

 

 

Add a ModelFIeld to RadClientDataSource Schema specifying the Field DataType as Date

 

Create a GridDateTimeColumn for the Grid and set its DataField to point to that field in the data source. Also, you may want to format the Date using the DataFormatString and enable range filtering through the EnableRangeFiltering property.

 

Results

RadGrid with no filtering applied

 

RadGrid with Date Filtering applied, between 01/3/2021 and 10/03/2021

 

Regards,
Attila Antal
Progress Telerik