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.
Unfortunately, activation email could not send to your email. Please try again.

Issues while binding grid in hierarchy

Thread ID:

Created:

Updated:

Platform:

Replies:

116864 Jun 23,2014 04:38 AM Jun 26,2014 09:58 AM ASP.NET Web Forms (Classic) 1
loading
Tags: GridGroupingControl
Ronak Jain
Asked On June 23, 2014 04:38 AM

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 [Syncfusion]
Replied On June 26, 2014 09:58 AM

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;