Specify Multiple Column Relationship

[Wayne Wengert]

I am trying to relate two tables in a dataset but cannot find the right
syntax to specify that the relationship consists of two columns. The
following code specifies a single column but I need to add a 2nd column
("SeqNbr") to that to specify a unique relation?

Dim ShowSetsRel As DataRelation = ds1.Relations.Add("ShowSets", _

ds1.Tables("CGShows").Columns("EventID"), _

ds1.Tables("CGPerfSched").Columns("EventID"))

 

[William Ryan eMVP]

Here's an example. If you have multiple columns, then use an Array of Data
Columns http://www.knowdotnet.com/articles/datarelation-printable.html

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[Wayne Wengert]

Thanks William - That was a quick response. I would never have figured that
out without the pointer - Looks like it works now.

FYI, there are a couple of typos in the section shown here (Colum should be
"Column" and "DetailColumns = New DataColumns()" should be "DetailColumn =
New DataColumns()"

===========================================
TransactionColumns = New DataColum(){ds.Tables(0).Columns("TransID"),
ds.Tables(0).Columns("CustomerID"), ds.Tables(0).Columns("SalePersonID")}
DetailColumns = New DataColumns(){ds.Tables(1).Columns("TransID"),
ds.Tables(1).Columns("CustomerID"), ds.Tables(1).Columns("SalesPersonID")}
===========================================


Wayne

 

[Wayne Wengert]

That second typo is " New DataColumns" that should be "New DataColumn"

Sorry about that.

 

[William Ryan eMVP]

Thanks Wayne - Sorry about that. I really need to run those things through
Word's spell checked ;-)

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups