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

Expand rebinds mastertable and detail tables

5 Answers 199 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mounir Maghraoui
Top achievements
Rank 1
Mounir Maghraoui asked on 03 May 2010, 10:59 AM
Hi,
I am using an hierarchial radgridWhen a user expands a row in the mastertable, it causes the rebind of all the grid ! This happens even it isn't the first time the row is been expanded. This seems to be a big problem  because of the size of the DB and the SQL it needs to execute.
Is there a way, please, to stop the rebind of the master and detail tables after the first load of the grid ?

Regards,
Mounir

5 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 03 May 2010, 01:07 PM
Hi Mounir,

You could set the HierarchyLoadMode property of GridTableView to Client, which in turn expands the items in client-side instead of postback to the server. In the Client mode, the roundtrip to the database happens only when grid is bound.

Read through the documentation for more information on Hierarchy load modes

Regards,
Princy.
0
Mounir Maghraoui
Top achievements
Rank 1
answered on 03 May 2010, 04:18 PM
Hi Princy,
As you sed, I have set the HierarchyLoadMode property of GridTableView to Client. This works but,unfortunately , it causes an other problem:
I am using the solution described here on the telerik web site to retain expanded selected state in hierarchy on rebind. After setting HierarchyLoadMode to Client, this no longer works.
0
Mounir Maghraoui
Top achievements
Rank 1
answered on 03 May 2010, 04:19 PM
Hi Princy,
As you sed, I have set the HierarchyLoadMode property of GridTableView to Client. This works but,unfortunately , it causes an other problem:
I am using the solution described here on the telerik web site to retain expanded selected state in hierarchy on rebind. After setting HierarchyLoadMode to Client, this no longer works.
0
Mounir Maghraoui
Top achievements
Rank 1
answered on 03 May 2010, 04:21 PM
Hi Princy,
As you sed, I have set the HierarchyLoadMode property of GridTableView to Client. This works but,unfortunately , it causes an other problem:
I am using the solution described here on the telerik web site to retain expanded selected state in hierarchy on rebind. After setting HierarchyLoadMode to Client, this no longer works.

Thanks,
Mounir
0
Mounir Maghraoui
Top achievements
Rank 1
answered on 03 May 2010, 04:26 PM
Hi Princy,
As you sed, I have set the HierarchyLoadMode property of GridTableView to Client. This works but,unfortunately , it causes an other problem:
I am using the solution described here on the telerik web site to retain expanded selected state in hierarchy on rebind. After setting HierarchyLoadMode to Client, this no longer works.

Thanks,
Mounir
Tags
Grid
Asked by
Mounir Maghraoui
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Mounir Maghraoui
Top achievements
Rank 1
Share this question
or