This documentation is archived and is not being maintained.

ForeignKeyConstraint.UpdateRule Property

Gets or sets the action that occurs across this constraint on when a row is updated.

[Visual Basic]
Public Overridable Property UpdateRule As Rule
[C#]
public virtual Rule UpdateRule {get; set;}
[C++]
public: __property virtual Rule get_UpdateRule();
public: __property virtual void set_UpdateRule(Rule);
[JScript]
public function get UpdateRule() : Rule;
public function set UpdateRule(Rule);

Property Value

One of the Rule values. The default is Cascade.

Example

[Visual Basic] The following example creates a ForeignKeyConstraint, sets various of its properties, and adds it to a DataTable object's ConstraintCollection.

[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 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 null values when a value is deleted.
   myFKC.DeleteRule = Rule.SetNull
   myFKC.UpdateRule = Rule.Cascade
   myFKC.AcceptRejectRule = AcceptRejectRule.Cascade
   ' Add the constraint, and set EnforceConstraints to true.
   myDataSet.Tables("Suppliers").Constraints.Add(myFKC)
   myDataSet.EnforceConstraints = True
End Sub

[C#, C++, JScript] No example is available for C#, C++, or JScript. To view a Visual Basic example, click the Language Filter button Language Filter in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

See Also

ForeignKeyConstraint Class | ForeignKeyConstraint Members | System.Data Namespace | AcceptRejectRule | Rule

Show: