Custom implementation of filtering and sorting

[Mariusz]

Hello everybody,

We need to create own implementation of RadGrid server filtering and sorting without using OData Web Services.

So, if the user choose filter from GridView, we want to create query to our custom Web Service. Web Service will return filtered and sorted data.

RadGrid shouldn't filter data by self.

We've try to write own implementation of QueryableCollectionView and use it as grid ItemsSource. Our collection implements ICollectionView, IQueryableCollectionView.
Unfortunately doesn't work. RadGrid is still filtering data in memory.

Please help.

[Ivan Petrov]

Hi Mariusz,

Binding RadGridView to any IQueriable collection should give all the control to the collection for any data operations that come from RadGridView. I would need more info on your approach and implementation to give you an accurate response. If you can provide a sample project that would be of great help to clarify the situation.

Another option is to use the filtering/filterd and sorting/sorted events. You can cancel the *ing events and execute your filtering/sorting logic.

A slightly different approach would be to check out RadVirtualGrid where the idea by design is to leave all data operations to the developer.

Looking forward to your reply.

Regards,
Ivan Petrov
Progress Telerik