执行SQL语句报错,Help!!! Post By:2011/7/18 17:15:00 [只看该作者]
我的代码是:
在表事件DataRowDeleting里代码如下:
'如果不是新增行,则删除SQL数据表上对应的行 If e.DataRow.RowState <> DataRowState.Added Then Dim cmd As New SQLCommand cmd.CommandText = "DELETE FROM {Product} WHERE _Identify = '" & e.DataRow("_Identify") & "'" cmd.ExecuteNonQuery() End If
执行时报错,然后又在命令窗口中测试下面代码:
Dim cmd As New SQLCommand cmd.CommandText = "DELETE FROM {Product} WHERE _Identify = 26" cmd.ExecuteNonQuery()