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.

Nesting multiple tables

Thread ID:

Created:

Updated:

Platform:

Replies:

97874 Jan 17,2011 08:50 AM Jan 18,2011 07:15 AM Windows Forms 1
loading
Tags: GridControl
Ivan Moreira
Asked On January 17, 2011 08:50 AM

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 07:15 AM

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.

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.

;