We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Issues while binding grid in hierarchy

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.    


Attachment: New_folder_ebb490ee.rar

1 Reply

SS Satheeskumar S Syncfusion Team June 26, 2014 01:58 PM UTC

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");


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.


Satheeskumar S

Attachment: WebApplication1_edc1b4d9.zip

Live Chat Icon For mobile
Up arrow icon