操作ACCESS表的怪事情
zjsyw 2011-02-20 07:39:57 一段简单代码操作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>不成功
百思不得其解