ForeignKeyConstraint::AcceptRejectRule Property
.NET Framework (current version)
Indicates the action that should take place across this constraint when AcceptChanges is invoked.
Assembly: System.Data (in System.Data.dll)
public: property AcceptRejectRule AcceptRejectRule { virtual AcceptRejectRule get(); virtual void set(AcceptRejectRule value); }
Property Value
Type: System.Data::AcceptRejectRuleOne of the AcceptRejectRule values. Possible values include None, and Cascade. The default is None.
The following example creates a ForeignKeyConstraint, sets its AcceptRejectRule, and adds the constraint to a DataTable object's ConstraintCollection.
' The next line goes into the Declarations section of the module: ' SuppliersProducts is a class derived from DataSet. Private suppliersProducts As SuppliersProducts Private Sub CreateConstraint() ' Declare parent column and child column variables. Dim parentColumn As DataColumn Dim childColumn As DataColumn Dim fkConstraint As ForeignKeyConstraint ' Set parent and child column variables. parentColumn = suppliersProducts.Tables("Suppliers").Columns("SupplierID") childColumn = suppliersProducts.Tables("Products").Columns("SupplieriD") fkConstraint = New ForeignKeyConstraint( _ "SuppierFKConstraint", parentColumn, childColumn) ' Set null values when a value is deleted. fkConstraint.DeleteRule = Rule.SetNull fkConstraint.UpdateRule = Rule.Cascade fkConstraint.AcceptRejectRule = AcceptRejectRule.Cascade ' Add the constraint, and set EnforceConstraints to true. suppliersProducts.Tables("Suppliers").Constraints.Add(fkConstraint) suppliersProducts.EnforceConstraints = True End Sub
.NET Framework
Available since 1.1
Available since 1.1
Show: