System.Data Namespace   DataRelation Class

Initializes a new instance of the DataRelation class using the specified DataRelation name and matched arrays of parent and child DataColumn objects, and a value indicating whether to create constraints.

[ VB ]
Overloads Public Sub New ( _
   ByVal relationName As String, _
   ByVal parentColumns ( ) As DataColumn, _
   ByVal childColumns ( ) As DataColumn, _
   ByVal createConstraints As Boolean _
)

[ C# ]
public DataRelation (
   string relationName,
   DataColumn [ ] parentColumns,
   DataColumn [ ] childColumns,
   bool createConstraints
);

[ C++ ]
public: DataRelation (
   String* relationName,
   DataColumn* parentColumns [ ],
   DataColumn* childColumns [ ],
   bool createConstraints
);

[ JScript ]
public function DataRelation (
   relationName : String,
   parentColumns : DataColumn [ ],
   childColumns : DataColumn [ ],
   createConstraints : Boolean
);

relationName

The name of the relation. If a null reference or an empty string ( "" ), a default name will be given when the created object is added to the DataRelationCollection.

parentColumns

An array of parent DataColumn objects.

childColumns

An array of child DataColumn objects.

createConstraints

A value indicating whether constraints are created. true, if constraints are created, otherwise, false.

The following example initializes a new DataRelation using this constructor, and adds it to the DataRelationCollection of a DataSet.

DataColumn parentCols [ ];
parentCols [ 0 ] = ds.Tables [ "Categories" ].Columns [ "CategoryID" ];

DataColumn childCols [ ];
childCols [ 0 ] = ds.Tables [ "Products" ].Columns [ "CategoryID" ];

DataRelation categoryId = new DataRelation ( "categoryId", parentCols, childCols, true );

// add the relation to the DataSet.
ds.Relations.Add ( categoryId );

Dim parentCols ( ) As DataColumn
parentCols ( 0 ) = ds.Tables ( "Categories" ).Columns ( "CategoryID" )

Dim childCols ( ) As DataColumn
childCols ( 0 ) = ds.Tables ( "Products" ).Columns ( "CategoryID" )

Dim categoryId As New DataRelation ( "categoryId", parentCols, childCols, true )

' add the relation to the DataSet.
ds.Relations.Add ( categoryId )

DataRelation Members   DataRelation Constructor Overload List   DataColumn   ForeignKeyConstraint   RelationName