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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Nesting multiple tables

Thread ID:

Created:

Updated:

Platform:

Replies:

97874 Jan 17,2011 01:50 PM UTC Jan 18,2011 12:15 PM UTC WinForms 1
loading
Tags: GridControl
Ivan Moreira
Asked On January 17, 2011 01:50 PM UTC

Hello,

How do I make more than 1 parent/child relation in GridGrouping?
The design of the nested tables would be:
table0 -> table1
table1 -> table 2
table1 -> table 3
table1 -> table n


I`m trying this way:


Dim dtArea As DataTable = dsInseridos.Tables(0)
Dim dtRegistro As DataTable = dsInseridos.Tables(1)
Dim AtributosRelation As GridRelationDescriptor = New GridRelationDescriptor()


AtributosRelation.RelationKind = RelationKind.RelatedMasterDetails
AtributosRelation.ChildTableName = "Registros"
AtributosRelation.RelationKeys.Add("ID_EXTRACAO_AREA", "id_extracao_area")
dtgInseridos.TableDescriptor.Relations.Add(AtributosRelation)
dtgInseridos.Engine.SourceListSet.Add("Areas", dtArea)
dtgInseridos.Engine.SourceListSet.Add("Registros", dtRegistro)

For count As Integer = 2 To dsInseridos.Tables.Count - 1

AtributosRelation = New GridRelationDescriptor()
AtributosRelation.RelationKind = RelationKind.RelatedMasterDetails
AtributosRelation.ChildTableName = "Atributos" & count
AtributosRelation.RelationKeys.Add("Registros.uniqueIdentifier", "Atributos" & count & ".UNIQUEIDENTIFIER")
dtgInseridos.TableDescriptor.Relations.Add(AtributosRelation)

dtgInseridos.Engine.SourceListSet.Add("Atributos" & count, dsInseridos.Tables(count))
Next





Jisha Joy [Syncfusion]
Replied On January 18, 2011 12:15 PM UTC

Hi Ivan,


The GridGroupingControl has the capability of binding several related tables.

Please refer to the following sample under "Relations And Hierarchy" from our sample browser,


C:\Syncfusion\8.4.0.10\Windows\Grid.Grouping.Windows\Samples\2.0\Relations And Hierarchy

Regards,
Jisha


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.

Warning Icon 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.Close Icon

;