这么简单的东西搞了一晚上也没搞通,教科书上的代码呀,以往直接用insert往里插可以,今天用update更新怎么都插不进数据库里,更新时也不报错,就是数据库里没记录。
数据库是access,有主键,oleDbConnection2打开正常
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter( "select * from dept",oleDbConnection2);
OleDbCommandBuilder db = new OleDbCommandBuilder(da);
da.FillSchema(ds, SchemaType.Source, "a");
da.Fill(ds, "a");
DataRow dr =ds.Tables[0].NewRow();
dr.BeginEdit();
dr["dept_code"] = "123";
dr["dept_name"] = "456";
dr["py_code"] = "789";
ds.Tables[0].Rows.Add(dr);
dr.EndEdit();
ds.Tables[0].AcceptChanges();
da.Update(ds, "a");
数据库是access,有主键,oleDbConnection2打开正常
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter( "select * from dept",oleDbConnection2);
OleDbCommandBuilder db = new OleDbCommandBuilder(da);
da.FillSchema(ds, SchemaType.Source, "a");
da.Fill(ds, "a");
DataRow dr =ds.Tables[0].NewRow();
dr.BeginEdit();
dr["dept_code"] = "123";
dr["dept_name"] = "456";
dr["py_code"] = "789";
ds.Tables[0].Rows.Add(dr);
dr.EndEdit();
ds.Tables[0].AcceptChanges();
da.Update(ds, "a");
然后写入数据库就看你的了
DataSet ds = new DataSet();
oleDbDataAdapter1.FillSchema(ds, SchemaType.Source, "a");
oleDbDataAdapter1.Fill(ds, "a");
DataRow dr =ds.Tables[0].NewRow();
dr.BeginEdit();
dr["dept_code"] = "123";
dr["dept_name"] = "456";
dr["py_code"] = "789";
ds.Tables[0].Rows.Add(dr);
dr.EndEdit();
oleDbDataAdapter1.Update(ds, "a");