RadGrid Excel-like Filtering For DateTime On ASP>NET Web Form

[Harikrishna]

How to show the filter check list item for a datetime column as like excel. Like the Attached image below.

[Doncho]

Hello,

One option to achieve a similar filtering functionality is to use the Filter Template and define a custom Filtering structure.

Check out the following resources regarding FilterTemplate:

• https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/filtering/filter-template 
• https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/filter-templates/defaultcs.aspx - refer to the GridDateColumn (Order Date) in the second Grid in the demo

For instance, a RadTreeView can be embedded in the Grid as a filtering control. The items in the RadTreeView (the data source of the tree view) should be generated based on the Data bound to the GridDataColumn in question. More additional code will be needed for handling the selection of the TreeView and applying the filter on the Grid accordingly.

Note that this is just an idea to consider as the desired functionality is not exposed as a built-in feature of the RadGrid. The suggested approach is not tested and its implementation could be quite tricky and for sure requires investing a lot of time and effort in custom coding.

I hope you will find this information useful.

Kind regards,
Doncho
Progress Telerik

[Harikrishna]

Thank you.. will try