[Solved] Custom filtering when using ADO.NET DataService

[Ulrik Born]

Hi,

We're using a RadGrid client-side bound to a ADO.NET DataService. We would like to use some custom input boxes above the grid to let the user specify a filter that cannot easily be specified using the built-in column-filters in the grid.

Our filter input can be translated to a textual LINQ query. Is there any way we can tell the grid to append our filter to the query it makes against the data service and thereby make it show only the rows that matches our custom filter?

Thanks in advance
Ulrik

[Nikolay Rusev]

Hello Ulrik,

You can use RadGrid client filter function. Calling this function will cause RadGrid to call the service with properly build where expressions.  If there are already filter expressions they will be applied along with new filter expression.
You can use the second grid on the following demo for startup:
http://demos.telerik.com/aspnet-ajax/grid/examples/clientbinding/defaultcs.aspx

All the best,
Rusev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.