Initializes a new instance of the ForeignKeyConstraint class.
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[]);
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
ForeignKeyConstraint Class | ForeignKeyConstraint Members | System.Data Namespace