Bagikan melalui


ForeignKeyConstraint.AcceptRejectRule Properti

Definisi

Menunjukkan tindakan yang harus dilakukan di seluruh batasan ini saat AcceptChanges() dipanggil.

public:
 virtual property System::Data::AcceptRejectRule AcceptRejectRule { System::Data::AcceptRejectRule get(); void set(System::Data::AcceptRejectRule value); };
public virtual System.Data.AcceptRejectRule AcceptRejectRule { get; set; }
[System.Data.DataSysDescription("ForeignKeyConstraintAcceptRejectRuleDescr")]
public virtual System.Data.AcceptRejectRule AcceptRejectRule { get; set; }
member this.AcceptRejectRule : System.Data.AcceptRejectRule with get, set
[<System.Data.DataSysDescription("ForeignKeyConstraintAcceptRejectRuleDescr")>]
member this.AcceptRejectRule : System.Data.AcceptRejectRule with get, set
Public Overridable Property AcceptRejectRule As AcceptRejectRule

Nilai Properti

Salah AcceptRejectRule satu nilai. Nilai yang mungkin termasuk None, dan Cascade. Default adalah None.

Atribut

Contoh

Contoh berikut membuat ForeignKeyConstraint, mengatur AcceptRejectRule, dan menambahkan batasan ke DataTable objek 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

Keterangan

Perubahan pada DataRow atau DataTable tidak final sampai AcceptChanges metode dipanggil. Pada saat itu, AcceptRejectRule menentukan jalannya tindakan pada nilai apa pun yang telah diubah atau dihapus.

Berlaku untuk

Lihat juga