sqlStr = "select *from newsType";
DataSet ss = new DataSet();
OleDbConnection oleconn = new OleDbConnection(Access);
OleDbDataAdapter olecomm = new OleDbDataAdapter(@"select * from newsType", oleconn);//执行
OleDbCommandBuilder cb = new OleDbCommandBuilder(olecomm);
//为ss赋sql server的值
ss = sqlDB.ExecSet(sqlStr);
ss.Tables[0].TableName = "newsType";
olecomm.Update(ss, "newsType");//更新到access中
ss.AcceptChanges();
oleconn.Close();
更新不进去,又没抛异常直接过去了
DataSet ss = new DataSet();
OleDbConnection oleconn = new OleDbConnection(Access);
OleDbDataAdapter olecomm = new OleDbDataAdapter(@"select * from newsType", oleconn);//执行
OleDbCommandBuilder cb = new OleDbCommandBuilder(olecomm);
//为ss赋sql server的值
ss = sqlDB.ExecSet(sqlStr);
ss.Tables[0].TableName = "newsType";
olecomm.Update(ss, "newsType");//更新到access中
ss.AcceptChanges();
oleconn.Close();
更新不进去,又没抛异常直接过去了
