一段简单代码操作ACCESS表bm ,就两个字段:bm_id 自动增加的长整型,bm_name char(10)
表里就几条记录
bm_id bm_name
1 a
2 b
3 c
4 d
<1>string sql_string = "delete from bm where bm_id=3";
<2>string sql_string = "update bm set bm_name='aaa' where bm_id=2";
OleDbConnection olecon = DB.dbconnection();
try
{
olecon.Open(); OleDbCommand sqlcom = new OleDbCommand(sql_string, olecon); sqlcom.ExecuteNonQuery(); sqlcom.Dispose(); }
catch (Exception ee)
{
Label1.Text = ee.Message;
}
finally
{
olecon.Close();
}
执行<1>是正常的,执行<2>不成功
百思不得其解
表里就几条记录
bm_id bm_name
1 a
2 b
3 c
4 d
<1>string sql_string = "delete from bm where bm_id=3";
<2>string sql_string = "update bm set bm_name='aaa' where bm_id=2";
OleDbConnection olecon = DB.dbconnection();
try
{
olecon.Open(); OleDbCommand sqlcom = new OleDbCommand(sql_string, olecon); sqlcom.ExecuteNonQuery(); sqlcom.Dispose(); }
catch (Exception ee)
{
Label1.Text = ee.Message;
}
finally
{
olecon.Close();
}
执行<1>是正常的,执行<2>不成功
百思不得其解
string strSql = "UPDATE [bm] SET [bm_name]=? WHERE ID=? ";
OleDbCommand cmd = new OleDbCommand(strSql, cn);
cmd.Parameters.AddWithValue("?", textBox2.Text);
cmd.Parameters.AddWithValue("?", textBox1.Text);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
看看是否会更新全部记录。
说明应该是数据库有问题,或是.net底层引擎出问题。肯定不是程序代码问题。
string sql_string = "update bm set bm_name='aaa' where bm_id=2";
单引号,是不是有问题呀