用DataGridView删除数据库数据出现的问题
private void InitAdapter()
{
this._adapter.DeleteCommand = new System.Data.SqlClient.SqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[food] WHERE (([商品] = @Original_商品) AND ((@IsNull_单价 = 1 AND [单价] IS NULL) OR ([单价] = @Original_单价)))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
}
运行后删除一行数据,再点保存,报错提示“当传递具有已删除行的 DataRow 集合时,更新要求有效的 DeleteCommand。”
不知哪里出了错,望高人指点