datagrids + dataset relations.

M

mike55

Contributor
Joined
Mar 26, 2004
Messages
727
Location
Ireland
Have created a dataset with two tables, myMembers and myGroupMembership. Have assigned the column Member_ID in the myMembers table as a primary key.

Code: 
With dsDataset.Tables("myMembers")
                .PrimaryKey = New DataColumn() _
                {.Columns("Member_ID")}
            End With

Have created a relationship between the two tables.
Code: 
 dsDataset.Relations.Add(New DataRelation("relGroups", dsDataset.Tables("myGroups").Columns("Group_ID"), _
                                                                            dsDataset.Tables("myGroupMembership").Columns("Group_ID"), True))

I now want to bind the result of the two tables to a single datagrid... question is how??

Mike55
 
Back
Top