我用ADO.NET访问Access数据库,记录不能插入
各位大虾,小弟用ADO.NET访问Access数据库,想通过Dataset添加DataRow,可是老是添加不了,代码如下,请各位高手指教。感激不尽!
string cmdTxt;
cmdTxt = "select username, password from userinfo";
OleDbCommand selectCmd = new OleDbCommand(cmdTxt, dbConnection);
OleDbDataAdapter da = new OleDbDataAdapter(selectCmd);
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(da);
System.Data.DataSet dataset = new System.Data.DataSet("test");
da.Fill(dataset, "testtable");
System.Data.DataTable table = dataset.Tables["testtable"];
System.Data.DataRow row = dataset.Tables["testtable"].NewRow();
row.ItemArray[0] = txtUserName.Text;
row.ItemArray[1] = txtPassword.Text;
dataset.Tables["testtable"].Rows.Add(row);
dataset.AcceptChanges();
int i = da.Update(dataset.Tables["testtable"]); dbConnection.Close();
MessageBox.Show("OK!");