This is a migrated thread and some comments may be shown as answers.

Does RadGridView have a virtual mode?

1 Answer 135 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Tony
Top achievements
Rank 1
Tony asked on 30 Sep 2011, 04:15 PM
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

1 Answer, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 03 Oct 2011, 06:54 AM
Hello Tony,

 Have you seen our virtual collection? Please check this example for more info. The demo is for Silverlight however the same approach can be used in WPF as well. Furthermore in WPF you can simply pass IQueryable to the constructor and our virtual collection will do the rest.

Regards,
Vlad
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Tags
GridView
Asked by
Tony
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Share this question
or