We have a WCF service which will house all of our application's data access. Our problem is that we want to be able to show all records [numbering thousands, sometimes hundreds of thousands] in a RadGridView, but we want to have one large list, as opposed to splitting up the data set in pages as far as the UI is concerned. Basically, we'd want one large list and we'd get the "visible" records for each "current view". We don't want the user to have to know about and/or keep track of the individual pages in the UI, however.
We can manually fetch "pages" of data so when the user browses to record #50 and the gridview shows 100 records that are visible, we can query the WCF service for records 50-149. In order to do this, we'd virtually load # records where # is the total count of record in the table and then just get the data for the currently-viewed page.
We can figure out how to get that done, but we are wondering if there is a way we can use data binding to achieve this. It would be preferrable to have a behind-the-scenes method that'd allow for paging on this level without complicating the UI [as much as possible, anyway].
Is a strategy that I've outlined possible? If so, it would be very useful to get some sample code that makes use of this strategy.
Sorry for the length of the message, but what we're asking for is pretty specific.
Thank you very much for any assistance