OleDbConnection MyConn = new OleDbConnection(source);
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();//select1,source);
MyAdapter.SelectCommand=new OleDbCommand(select1, MyConn ); //加上这句
OleDbCommandBuilder custCB = new OleDbCommandBuilder(MyAdapter);
MyConn.Open();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();//select1,source);
MyAdapter.SelectCommand=new OleDbCommand(select1, MyConn ); //加上这句
OleDbCommandBuilder custCB = new OleDbCommandBuilder(MyAdapter);
MyConn.Open();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();//select1,source);
select1="insert into table1(id,name) values(1,'name')";
MyAdapter.SelectCommand=new OleDbCommand(select1, MyConn ); //加上这句
OleDbCommandBuilder custCB = new OleDbCommandBuilder(MyAdapter);
MyConn.Open();
custCB.ExecuteNonQuery();
select1="insert into table1(id,name) values(1,'name')";
OleDbCommand Cmd = new OleDbCommand(select1, MyConn);
MyConn.Open();
Cmd.ExecuteNonQuery();
MyConn.Close();就可以了
OleDbConnection MyConn = new OleDbConnection(source);
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();//select1,source);
MyAdapter.SelectCommand=new OleDbCommand(select1, MyConn ); //加上这句
OleDbCommandBuilder custCB = new OleDbCommandBuilder(MyAdapter);------------------------------
DataSet ds = new DataSet ();
MyAdapter.Fill (ds);
// 加入的记录
DataRow row = ds.Tables[0].NewRow ();
row.BeginEdit ();
row["Field1"] = ...;
row["Field1"] = ...;...
row.EndEdit ();
ds.Tables[0].Rows.Add (row);MyAdapter.Update (ds);-----------------------------
四十年来家国,三千里地山河,凤阁龙楼连霄汉,玉树琼枝作烟箩。几曾识干戈?