How to specify DataRelation with several keys

  • Thread starter Thread starter Tony Johansson
  • Start date Start date
T

Tony Johansson

Hello!

Below is a DataRelation I have created where we have one primary key on the
parentside which is the Customer
DataRelation custOrderRel = thisDataSet.Relation.Add("custOrders",
thisDataSet.Tables["Customers"].Columns["CustomerID"],
thisDataSet.Tables["Orders"].Columns["CustomerID"]);

Now to my question how do I write a DataRelation if I have a primary key
that consist of two columns.

//Tony
 
Hello!

Below is a DataRelation I have created where we have one primary key on the
parentside which is the Customer
DataRelation custOrderRel = thisDataSet.Relation.Add("custOrders",
thisDataSet.Tables["Customers"].Columns["CustomerID"],
thisDataSet.Tables["Orders"].Columns["CustomerID"]);

Now to my question how do I write a DataRelation if I have a primary key
that consist of two columns.

//Tony
Click to expand...

The constructor for the DataRelation class has an overload that takes
an array of DataColumn objects. You should be able to use that.
Something like this: (untested and not complete):

DataRelation dr = new DataRelation("dataRelationName",
new DataColumn[] { thisDataSet.Tables
["parentTableName"].Columns["Column1"],

thisDataSet.Tables["parentTableName"].Columns["Column2"]},
new DataColumn[] { thisDataSet.Tables
["childTableName"].Columns["Column1"],

thisDataSet.Tables["childTableName"].Columns["Column2"]});

Chris
 
Back
Top