[Solved] Multi Level Dynamic Hierarchical Grid

[Wajih]

Can you Please Provide me the demo of Dynamic Multi level Parent-Child relation Rad Grid.I have gone through your demo of
Mixed Hierarchical Grid but in that demo you have defind three  levels Master Tabel-Detail table-Detail Table.But we don't have fixed level it will get increase depending upon relation.Please find the attched image.These levels will grows increasing depending upon data.

[Pavlina]

Hi,

Please refer to the following online demo demonstrating the ability of RadGrid to autogenerate hierarchy. By setting the AutoGenerateHierarchy to true the grid will automatically generate the hierarchy based on the tables in the DataSet and their relations with one another.
http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/autogeneratedhierarchy/defaultcs.aspx

Greetings,
Pavlina
the Telerik team

[Venkata]

Hi,

We also have the same case of creating dynamic multiple level parent-child relation Rad Grid and we are also not sure of depth of it. I am creating my RadGrid from code behind in the PageInit method. I can see that DataSet can be used generate hierarchy of details tables. But , I have couple of questions about this.

  1. There is really a lot of data that needs to go into detail tables and binding all this data in PageInit every time will cost a lot. I want to pull the data of detail table only when parent table row is expanded.

 2. We need to add GridTemplateColums like textbox and checkbox columns for each Master table and auto generated Detail table in the Rad Grid. How can I combine these columns with the columns in dataset ( if we were to use DataSet approach )

Can you help me with this...I am pretty new to Telerik..I tried all the KB articles..but haven't found the solution

[Shinu]

Hello Venkata,

You can achieve this by attaching the DetailTableDataBind event.Check the following demo for further information. Hope this helps.
Grid / Programmatic Binding

Thanks,
Shinu.

[Venkata]

Thank you. The demo in the link has fixed number of tables (3) defined derivatively. In my case I am not sure of the number of detail tables that I would have, I need to create detail tables on the fly and hierarchy can be arbitrary.

I have tried the approach given in this demo to generate arbitary hierarchy levels. But, the problem is I also want to add GridTemplateColumns ( checkboxes, textboxes ) for each generated detail table additional to the columns from dataset.

[Pavlina]

Hello Venkata,

Please refer to the online resources below for more information about how to achieve your goal:
http://www.telerik.com/help/aspnet-ajax/grid-programmatic-creation.html (Creating template columns programmatically section)
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/hierarchy/defaultcs.aspx

Greetings,
Pavlina
the Telerik team

[Toni]

Hi,
 I need to create a hierarchical grid structure, but we are not sure of depth it will have. depth of the grid may vary from 2 to 6 . All grids would have the same number of columns and same type. I need to know what approach should I follw...declaretively or programmaticaly creation , nestedview template or Master-details...demo that I saw was not much of the help...

thanks

[Pavlina]

Hello Toni,

In your case a possible option is to use AutoGenerated Hierarchy, where the grid automatically generates the entire hierarchical structure and retrieves the relations between the items. But note that this is only supported for binding to DataSet with relations between the tables in it.

Regards,
Pavlina
the Telerik team

[Ahmed Ilyas]

I understand this is an old post however I have recently come in a situation where I need this to display a menu permissions matrix. The menu items coming from the DB contain children (unlimited) for a parent.

how can I bind this custom list? I do not want any ajax calls but server side so it is dynamically generating the hierarchy and also being able to do a postback if say, a button has been pressed on that row.

I want to display custom columns (i.e literals, checkboxes etc...)
finally, I do not want the gray bar in the demo on the left handside to appear (even the arrow)

[Kiran]

Hello,
Can I have the event handler to the expander in this example. The event handler to get the corresponding child data of the parent.
Thanks,
Kiran Sattenapalli