oledb dataset更新数据问题,UPDATE语句错误?
ACCESS数据库
表:info
列:id(int长度4),name(char长度10),password(char长度16)
下面代码异常是UPDATE与语错误:
OleDbConnection con= new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\db\my.mdb");
con.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from info", con);
adapter.UpdateCommand = new OleDbCommand("update info set name=@name,password=@password where id=@id",con);
adapter.UpdateCommand.Parameters.Add("@name", OleDbType.Char, 10, "name");
adapter.UpdateCommand.Parameters.Add("@password", OleDbType.Char, 16, "password");
adapter.UpdateCommand.Parameters.Add("@id", OleDbType.Integer, 4, "id");
DataSet set = new DataSet();
adapter.Fill(set);
set.Tables[0].Rows[0][2] = "123456";
adapter.Update(set);
con.Close();
错在那?