我想把数据表(LanMu)里面的第一行的栏目信息改为aaaaaa,执行下面代码后数据表里面的数据没有改变,但使用OleDbDataReader读取出来的内容却又是aaaaaa,这到底是为什么?
string connstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\webCount.mdb;Persist Security Info=False;";
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
OleDbCommand cmd = new OleDbCommand(@"update LanMu set LanMu = 'aaaaaa' where id = 1", conn);
cmd.ExecuteNonQuery();
OleDbCommand cmd1 = new OleDbCommand("Select id,LanMu from LanMu", conn);
OleDbDataReader dr = cmd1.ExecuteReader();
while (dr.Read()) {
Console.WriteLine("输出栏目:" + dr[0].ToString() + " " + dr[1].ToString());
}
conn.Close();
输出的结果 :
输出栏目:1 aaaaaa
输出栏目:2 党务公开