Custom Filtering on RadGridView

[John]

Hello,

We're trying to create a data paging system using the RadGridView, and are having difficulty with the filtering.
Here's the scenario. 

First, we set up the filtering mode = Filter row.

When a filter is applied, we intercept the Colum info that's being filtered in the "Grid_Filtering" event to create our Filtering information to pass back to the web services to get data.  

The issues is that the grid filters (Let's say it reduces the rows to 3), then as we call our web service to get data from the back end, which may have 10 items in the dataset.

My question is;  Are there any examples where one can gather the filter information, then prevent the internal grid from filtering, then applying our new data set?

We've cobbled it together, but it looks bad having the grid display one data set, only to have it clear out and load another.
What we're trying to do is pull the pages via webservice instead of loading the entire dataset into memory.

[Dilyan Traykov]

Hello John,

I believe you can use RadDataServiceDataSource as it can be used to perform data operations (such as filtering) directly on the server.

We do have an example in our SDK Samples Browser about how to consume a OData 4 service using it. The source code is also available in our GitHub repository.

If a similar approach does not work for you, please share your current implementation so that I can suggest potential improvements or alternatives.

Regards,
Dilyan Traykov
Progress Telerik