ForeignKeyConstraint Class   System.Data Namespace

---

Initializes a new instance of the ForeignKeyConstraint class.

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

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

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

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

[ VB ] NOTE: This example uses one of the overloaded versions of the ForeignKeyConstraint constructor. For other examples that may be available, see the individual overload topics.

[ VB ] 
' 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 pCol As DataColumn
   Dim cCol As DataColumn
   Dim myFKC As ForeignKeyConstraint
   ' set parent and child column variables.
   pCol = myDataSet.Tables ( "Suppliers" ).Columns ( "SupplierID" )
   cCol = myDataSet.Tables ( "Products" ).Columns ( "SupplieriD" )
   myFKC = New ForeignKeyConstraint ( "SuppierFKConstraint", pCol, cCol )
   ' set various properties of the constraint.
   With myFKC
      .DeleteRule = Rule.SetNull
      .UpdateRule = Rule.Cascade
      .AcceptRejectRule = AcceptRejectRule.Cascade
   End With
   ' add the constraint, and set EnforceConstraints to true.
   myDataSet.Tables ( "Suppliers" ).Constraints.Add myFKC
   myDataSet.EnforceConstraints = True
End Sub

ForeignKeyConstraint Members

Suggested Reading