我们可以使用访问列值C＃删除Microsoft访问表行吗？ [英] Can we delete Microsoft access table rows using access column values C#

问题描述

我需要使用访问列值删除微软访问表行C＃



我尝试过：



我这样做了

I need to delete microsoft access table rows using access column values C#

What I have tried:

I have done in this way

//string str = "insert into        eBSV_Rules(Idx,RuleCode,RuleName,TableName,Conditions,DisplayMessage,,) values     (@id,@name)";
string sql = " DELETE FROM eBSV_Rules WHERE [Idx] = ? ";
//'" +  ? + "'
my_con.Open();
OleDbCommand My_Command = new OleDbCommand(sql, my_con);
My_Command.ExecuteNonQuery();

bindgrid();

推荐答案

您从未将OldDbParameter对象添加到OleDbCommand的Parameters集合中。你有什么需要填补？你有查询。

You never added the OldDbParameter object to the OleDbCommand's Parameters collection. You kind of need that to fill the ? you have in the query.

这篇关于我们可以使用访问列值C＃删除Microsoft访问表行吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！