Kindly let us know if it is possible to bind different DataTable / Dataset for each child band as in the below image in WebHierarchialDataGrid.
If possible kindly let us know on the way to achieve the same.
Thanks in Advance
Hello,Thank you for the image you have sent.You can use a DataSet and with several different tables. You will have to set the different relations between the tables and use PrimaryKeys. To illustrate this approach I have attached a sample which includes a parent, child and grandchild hierarchical relations or a DataSet with three tables - Years, Months and Days. You can find it as an attached file.Let me know if you have further questions concerning this matter.1172.WHDG_DataSet.zip
We are using only one level of hierarchy. But we need different child table in each row. The column structure of child table should vary for each row as highlighted in the below image
Thank you for the additional information.
If you know in advance how many tables you will use and with how many columns, you can declare them all as different bands, for reference see the modified sample. If you do not know you can turn AutoGenerateColumns and AutoGenerateBands to true.
In both scenarios you will need to set the relations. You will have one parent table and you should make a different relation for each different row, which in your scenario will be a different table.8105.WHDG_DataSet_Modified.zip