I've built a WPF application which uses the RadGridView control on a number of different windows. The point of these windows is to query the database for data and display the results.
As this is a WPF application and not a Web application, we feel that the application should not page the data, which can change in the background while the user is viewing a page of data. Ideally, the control should work in the following manner for very large data sets (above 100,000 rows):
1. The control retrieves the IDs of all and all matching rows from the database and caches them.
2. Using the cached IDs, the control retrieves a reasonably sized subset of the data to display for the user, say 1,000 rows.
3. If the user scrolls to an area of the result set where the data has not yet been retrieved, the control retrieves more data, again a resasonable sized subset.
Working in this manner prevents the program from using huge amounts of memory and time, as it would if the program just retrieved all of the data at once.
Is there a way to implement this type of functionality with the RadGridView control?
Thanks
Tony
As this is a WPF application and not a Web application, we feel that the application should not page the data, which can change in the background while the user is viewing a page of data. Ideally, the control should work in the following manner for very large data sets (above 100,000 rows):
1. The control retrieves the IDs of all and all matching rows from the database and caches them.
2. Using the cached IDs, the control retrieves a reasonably sized subset of the data to display for the user, say 1,000 rows.
3. If the user scrolls to an area of the result set where the data has not yet been retrieved, the control retrieves more data, again a resasonable sized subset.
Working in this manner prevents the program from using huge amounts of memory and time, as it would if the program just retrieved all of the data at once.
Is there a way to implement this type of functionality with the RadGridView control?
Thanks
Tony