DataRelation.ChildKeyConstraint Property

System.Data Namespace DataRelation Class

Returns the ForeignKeyConstraint for the relation.

Script	[ ForeignKeyConstraint variable = ] DataRelation.ChildKeyConstraint

variable	A ForeignKeyConstraint

The property is read only with no default value.

The following example sets the UpdateRule, DeleteRule, and AcceptReject rule for the ForeignKeyConstraint associated with the DataRelation.

private void SetChildKeyConstraint ( DataSet ds ) {
   DataColumn cCol, pCol;
   // set child and parent columns.
   pCol = ds.Tables [ "Suppliers" ].Columns [ "SupplierID" ];
   cCol = ds.Tables [ "Products" ].Columns [ "SupplierID" ];
   DataRelation dr = new DataRelation ( "SuppliersConstraint", pCol, cCol )

   ForeignKeyConstraint fk = dr.ChildKeyConstraint;
   fk.DeleteRule = Rule.SetNull;
   fk.UpdateRule = Rule.Cascade;
   fk.AcceptRejectRule = AcceptRejectRule.Cascade;
}

Private Sub SetChildKeyConstraint ( ds As DataSet )
   Dim cCol, pCol As DataColumn
   ' set child and parent columns.
   pCol = ds.Tables ( "Suppliers" ).Columns ( "SupplierID" )
   cCol = ds.Tables ( "Products" ).Columns ( "SupplierID" )
   Dim dr As New DataRelation ( "SuppliersConstraint", pCol, cCol )

   Dim fk As ForeignKeyConstraint = dr.ChildKeyConstraint
   fk.DeleteRule = Rule.SetNull
   fk.UpdateRule = Rule.Cascade
   fk.AcceptRejectRule = AcceptRejectRule.Cascade
End Sub

DataRelation Members AcceptRejectRule ParentKeyConstraint Rule

Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics

DataRelation.ChildKeyConstraint Property

Syntax

Property Value

Example

See Also