Loading Data On-Demand when ChildGridViewTemplate is Expanded

4 posts, 0 answers
  1. Tom Chien
    Tom Chien avatar
    125 posts
    Member since:
    Jun 2009

    Posted 21 Oct 2009 Link to this post

    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.

  2. Julian Benkov
    Julian Benkov avatar
    1135 posts

    Posted 23 Oct 2009 Link to this post

    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.
  3. Hannah
    Hannah avatar
    37 posts
    Member since:
    May 2013

    Posted 31 May 2013 Link to this post

    "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.


  4. Stefan
    Stefan avatar
    2911 posts

    Posted 05 Jun 2013 Link to this post

    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.
    RadChart for WinForms is obsolete. Now what?
Back to Top