Issues while binding grid in hierarchy

[Ronak Jain]

We have two tables in our system one is parent and other is child named as visible in attached files.In parent table screenshot there are two fields one is Acoid and other is Gender.

    As per sample given in syncfusion for grid ,data drilldown is based on one column but we want grid to drilldown and show data based on both fields which are AcoId and Gender.Please send us sample code to perform this as early as possible.    

Thanks

Ronak

Attachment: New_folder_ebb490ee.rar

[Satheeskumar S]

Hi Ronak,

Thanks for your interest in Syncfusion Products.

We are glad to let you know that we have achieved your requirement. We have prepared a simple sample to demonstrate Hierarchical grid with two relations.

Please refer the below code snippets.

DataTable Parent = GetParent();

DataTable Child = GetChild();

GridRelationDescriptor ChildTableRelationDescriptor = new GridRelationDescriptor();

ChildTableRelationDescriptor.ChildTableName = "Orders";

ChildTableRelationDescriptor.RelationKind = RelationKind.RelatedMasterDetails;

ChildTableRelationDescriptor.RelationKeys.Add("CustomerID", "CustomerID");

ChildTableRelationDescriptor.RelationKeys.Add("ShipCountry", "Country");

GridGroupingControl1.TableDescriptor.Relations.Add(ChildTableRelationDescriptor);

In the sample, we have added two relations for CustomerID and Country field. Could you please expand the CusomerID “Bergs” it has a two Ship Country names such as Swedan and Brazil. If we have added ShipCountry as another relation, it shows only the Country name collection of the Current record.

Please let us know if you need any further assistance.

Regards,

Satheeskumar S

Attachment: WebApplication1_edc1b4d9.zip