NGWS SDK Documentation  

This is preliminary documentation and subject to change.
To comment on this topic, please send us email at ngwssdk@microsoft.com. Thanks!

ForeignKeyConstraint Constructor

Initializes a new instance of the ForeignKeyConstraint class.

Overload List

Initializes a new instance of the ForeignKeyConstraint class with the specified parent and child DataColumn objects.

[Visual Basic] Overloads Public Sub New(DataColumn, DataColumn)
[C#] public ForeignKeyConstraint(DataColumn, DataColumn);
[C++] public: ForeignKeyConstraint(DataColumn*, DataColumn*);
[JScript] public function ForeignKeyConstraint(DataColumn, DataColumn);

Initializes a new instance of the ForeignKeyConstraint class with the specified name, parent and child DataColumn objects.

[Visual Basic] Overloads Public Sub New(String, DataColumn, DataColumn)
[C#] public ForeignKeyConstraint(String, DataColumn, DataColumn);
[C++] public: ForeignKeyConstraint(String*, DataColumn, DataColumn);
[JScript] public function ForeignKeyConstraint(String, DataColumn, DataColumn);

Initializes a new instance of the ForeignKeyConstraint class with the specified arrays of parent and child DataColumn objects.

[Visual Basic] Overloads Public Sub New(DataColumn(), DataColumn())
[C#] public ForeignKeyConstraint(DataColumn[], DataColumn[]);
[C++] public: ForeignKeyConstraint(DataColumn*[], DataColumn*[]);
[JScript] public function ForeignKeyConstraint(DataColumn[], DataColumn[]);

Initializes a new instance of the ForeignKeyConstraint class with the specified name, and arrays of parent and child DataColumn objects.

[Visual Basic] Overloads Public Sub New(String, DataColumn(), DataColumn())
[C#] public ForeignKeyConstraint(String, DataColumn[], DataColumn[]);
[C++] public: ForeignKeyConstraint(String*, DataColumn[], DataColumn[]);
[JScript] public function ForeignKeyConstraint(String, DataColumn[], DataColumn[]);

Example [Visual Basic]

Note   This example shows how to use one of the overloaded version of the ForeignKeyConstraint constructor. For other examples that may be available, see the individual overload topics.

[Visual Basic]

' The next line goes into the Declarations section of the module:
' SuppliersProducts is a class derived from DataSet.
Private myDataSet As SuppliersProducts 


Private Sub CreateConstraint()
   ' Declare parent column and child column variables.
   Dim pCols(1) As DataColumn
   Dim cCols(1) As DataColumn
   Dim myFKC As ForeignKeyConstraint
   ' Set parent and child column variables.
   pCols(0) = MyDataSet.Tables("OrderDetails").Columns("OrderID")
   pCols(1) = MyDataSet.Tables("OrderDetails").Columns("ProductID")
   cCols(0) = MyDataSet.Tables("Sales").Columns("OrderID")
   cCols(1) = MyDataSet.Tables("Sales").Columns("ProductID")
   myFKC = New ForeignKeyConstraint("ProductSalesOrders", pCols, cCols)
   ' Set various properties of the constraint.
   With myFKC
      .DeleteRule = Rule.SetDefault
      .UpdateRule = Rule.Cascade
      .AcceptRejectRule = AcceptRejectRule.Cascade
   End With
   ' Add the constraint, and set EnforceConstraints to true.
   myDataSet.Tables("OrderDetails").Constraints.Add myFKC
   myDataSet.EnforceConstraints = True
End Sub

See Also

ForeignKeyConstraint Class | ForeignKeyConstraint Members | System.Data Namespace