access数据库无法写入,如何解决
我采用C#连接access,数据库文件权限的everoen及user都已设为完全控制,但依然无法写入数据。
- C# code
private void button2_Click(object sender, EventArgs e) { CData _cData = new CData(); string sql = "update camel_thinner set thinner_name='呵呵'"; _cData.setDS(sql); }private void button3_Click(object sender, EventArgs e) { CData _cData = new CData(); string sql = "insert into camel_thinner(thinner_name) values('稀释剂')"; _cData.setDS(sql); }public class CData { private OleDbConnection conn; private OleDbDataAdapter oda = new OleDbDataAdapter(); private OleDbCommand cmd; private DataSet myds = new DataSet(); public CData() { // // TODO: 在此处添加构造函数逻辑 // conn = new OleDbConnection(Properties.Settings.Default.connectionString); } public DataSet getDS(string strSQL) { myds = new DataSet(); oda = new OleDbDataAdapter(strSQL, conn); oda.Fill(myds); return myds; } public DataSet getDS2(string strSQL, int si, int mi) { conn.Open(); myds = new DataSet(); oda = new OleDbDataAdapter(strSQL, conn); oda.Fill(myds, si, mi, "tab1"); conn.Close(); return myds; } public bool setDS(string strSQL) { conn.Open(); cmd = new OleDbCommand(strSQL, conn); cmd.ExecuteNonQuery(); conn.Close(); return true; } }
请问如何解决,谢谢
[解决办法]
看一下是不是存在两个access的数据库文件,你在你的项目文件下找找看,以前好像遇到过类似的,其实数据已经写入数据库了,你打开看的只是此次数据库的复制备份版本。
[解决办法]
http://topic.csdn.net/u/20110225/18/618028a5-2089-4996-bb5a-18589a6ee77d.html