Dim dt As DataTable
Dim cmd As new SQLCommand
cmd.ConnectionName
cmd.CommandText = "select * from {Request_Purchase}"
dt = cmd.ExecuteReader(True)
For Each r As Row In Tables("Purchase Orders_Order_Add").Rows
For Each dr As DataRow In dt.DataRows
If r("Material") = dr("Material") Then
dr.Delete()
dt.Save
End If
Next
Next
我想直接删除另外一个表中的匹配项,但领导说不能在遍历中删除集合成员
我想不到更好的方法了,求帮忙想想啊 大哥