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

Loading Data On-Demand when ChildGridViewTemplate is Expanded

3 Answers 141 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Tom Chien
Top achievements
Rank 1
Tom Chien asked on 21 Oct 2009, 11:58 AM
I have a 4-level RadGridView with a total of 3 Sibling ChildGridViewTemplates for a total of 7 GridViewTemplates (2 of them sharing a DataSet with 1 each of the other ChildGridViewTemplates).   I have one case that currently loads 44 k Rows total (between all GridViewTemplates) into the DataSets used by RadGridView taking ~8 seconds.  I'd like to cut that time down to no more than 1, maybe 2 seconds by suppressing data loads for ChildGridViewTemplates until each one is opened (i.e. it's ParentRow is expanded).  Once it's opened, the data for its Rows would stay in memory and possibly be cleared when it's closed (i.e. it's ParentRow is collapsed).  Of course, it would need to allow for multiple Cousin ChildGridViewTemplates being open at the same time (but if necessary, even that's optional if I can force close all other open Cousins).  I'm binding to DataSet's filled by SqlDataAdapter's.  My grid is read-only (well at the grid-level anyways, Rows will be edited using a separate Form per Row).

I imagine I need to handle the ChildViewExpanded Event, but I wanted to get your input before I stray too far down the wrong path.  Maybe I even need to change my binding method?

NOTE: I'm also considering a GridViewTemplate-level "Refresh" option.

2009Q2 (2009.2.9.729), VS 2005 (v8.0.50727.762 SP.050727-7600), .Net2 (2.0.50727), XP SP3, Core2Duo 2.99GHZ with 3GB.

3 Answers, 1 is accepted

Sort by
0
Julian Benkov
Telerik team
answered on 23 Oct 2009, 08:51 AM
Hello Tom Chien,

This functionality is not supported in the current edition of RadGridView. We are implementing custom hierarchys, on-demand loading, and self-referencing at the moment. The new hierarchy mechanism and operations will be available soon after Q3 2009 release.

Kind regards,
Julian Benkov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Hannah
Top achievements
Rank 2
answered on 31 May 2013, 08:44 PM
"available soon after Q3 2009 release"

Was this released?  I'm looking for information regarding this.  I have a child-grid with 300k+ rows and will certainly need to implement some level of memory management for this.

Thanks,

Wayne
0
Stefan
Telerik team
answered on 05 Jun 2013, 08:34 AM
Hi Wayne,

If I understand correctly you are asking whether load-on-demand functionality is implemented in RadGridView. If so, the answer is yes. You can find more information about this functionality at the following article: http://www.telerik.com/help/winforms/gridview-hierarchical-grid-load-on-demand-hierarchy.html.

I hope that you find this information useful.
 
Regards,
Stefan
Telerik
RadChart for WinForms is obsolete. Now what?
Tags
GridView
Asked by
Tom Chien
Top achievements
Rank 1
Answers by
Julian Benkov
Telerik team
Hannah
Top achievements
Rank 2
Stefan
Telerik team
Share this question
or