修改sql server compact数据库中的数据问题。。。

Question

我新建了一个本地数据库“dbtest.sdf”，当我执行完下面的更新数据的代码后，再打开dbtest.sdf数据库，发现里面的name列为‘aaa’的记录并没有被更新成‘hello’，请问这是为什么？

string constr = "Data Source=|DataDirectory|\\dbtest.sdf";
SqlCeConnection conn = new SqlCeConnection(constr);
conn.Open();
string s = "update test set name='hello' where name='aaa'";
SqlCeCommand command = new SqlCeCommand(s, conn);
command.ExecuteNonQuery();
conn.Close();

 

 

Answer 1

Hi,

建议使用SQLProfiler去trace一下操作日志。

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.