AcceptRejectRule Enumeration
.NET Framework (current version)
Determines the action that occurs when the AcceptChanges or RejectChanges method is invoked on a DataTable with a ForeignKeyConstraint.
Assembly: System.Data (in System.Data.dll)
| Member name | Description | |
|---|---|---|
| Cascade | Changes are cascaded across the relationship. | |
| None | No action occurs (default). |
Changes to a DataTable are not final until you call the AcceptChanges method. When either AcceptChanges or RejectChanges is called on a row in the parent table, the AcceptRejectRule value determines whether or not changes are propagated to corresponding rows in the child table.
The following example creates a ForeignKeyConstraint, sets various of its properties, including the AcceptRejectRule, and adds it to a DataTable object's ConstraintCollection.
Private Sub CreateConstraint(dataSet As DataSet, _ table1 As String, table2 As String, _ column1 As String, column2 As String) ' Declare parent column and child column variables. Dim parentColumn As DataColumn Dim childColumn As DataColumn Dim foreignKeyConstraint As ForeignKeyConstraint ' Set parent and child column variables. parentColumn = dataSet.Tables(table1).Columns(column1) childColumn = dataSet.Tables(table2).Columns(column2) foreignKeyConstraint = New ForeignKeyConstraint _ ("SupplierForeignKeyConstraint", parentColumn, childColumn) ' Set null values when a value is deleted. foreignKeyConstraint.DeleteRule = Rule.SetNull foreignKeyConstraint.UpdateRule = Rule.Cascade foreignKeyConstraint.AcceptRejectRule = AcceptRejectRule.None ' Add the constraint, and set EnforceConstraints to true. dataSet.Tables(table1).Constraints.Add(foreignKeyConstraint) dataSet.EnforceConstraints = True End Sub
.NET Framework
Available since 1.1
Available since 1.1
Show: