[Solved] Filtering with larger data sources and paging

[Michael Hassinger]

I am using a GridView control to display information from a domain data source that is pulling tens of thousands of records. I am using paging on the grid, with 100 records per page. Sorting works fine, in that clicking a column header causes a refresh from the database so on page 1 you'll be seeing the correctly sorted data.

Filtering, on the other hand, is problematic. The values displayed on the filter list are only the ones for the page of the grid you're on, which is ok. But when I type in a value in the text box of the filter, it still only filters on the visible records, instead of adding a filter to the domain data source and going back to the database.

Any suggestions for filtering a grid with hundreds of pages of data?

[Vlad]

Hello,

 If the grid is bound to DomainDataSource this is expected since there is no internal link between the grid filtering and DomainDataSource filtering - you need to do this manually similar to our demo. After three weeks with our first service pack we will release our own DomainDataSource (RadDomainDataSource) and this and many other will be supported out-of-the-box without any extra code.

All the best,
Vlad
the Telerik team

[Michael Hassinger]

The demo was a great example on how to get the grid filter descriptors to apply to the DomainDataSource. Thanks!