大家有没有用过DataRelation,我写了一个,不过怎么关联表的数据也不能删除~!!大家帮忙啊
代码我我贴:
我用的是northwind的两个表orders employees
: 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 = DataSetOrder.Tables("Orders").Columns("EmployeeID")
cCol = DataSetOrder.Tables("Employees").Columns("EmployeeID")
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.
DataSetOrder.Tables("Employees").Constraints.Add(myFKC)
DataSetOrder.EnforceConstraints = True
End Sub
Private Sub DataGrid2_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid2.DeleteCommand
'CreateRelation()
CreateConstraint()
Me.SqlCommand1.Parameters("@para1").Value = Me.Label1.Text
Me.SqlConnection1.Open()
Me.SqlCommand1.ExecuteNonQuery()
End Sub
大家看看~!