代码如下:
public void Page_Load(Object src,EventArgs e)
{
String myconnstr="Provider=SQLOLEDB;server=192.168.0.1;database=jtqcnews;uid=sa;";
OleDbConnection myconn=new OleDbConnection(myconnstr);
myconn.Open();
String sqlstr="update b1 set tiaomu='44444' where id=1003";
OleDbCommand mycomm=new OleDbCommand(sqlstr,myconn);
OleDbDataAdapter myadapter=new OleDbDataAdapter(`);
myadapter.UpdateCommand=mycomm;
myconn.Close();
}
为何以上代码不能实现数据更新???恳请路过赐教!
public void Page_Load(Object src,EventArgs e)
{
String myconnstr="Provider=SQLOLEDB;server=192.168.0.1;database=jtqcnews;uid=sa;";
OleDbConnection myconn=new OleDbConnection(myconnstr);
myconn.Open();
String sqlstr="update b1 set tiaomu='44444' where id=1003";
OleDbCommand mycomm=new OleDbCommand(sqlstr,myconn);
OleDbDataAdapter myadapter=new OleDbDataAdapter(`);
myadapter.UpdateCommand=mycomm;
myconn.Close();
}
为何以上代码不能实现数据更新???恳请路过赐教!
OleDbConnection myconn=new OleDbConnection(myconnstr);
myconn.Open();
String sqlstr="update b1 set tiaomu='44444' where id=1003";
OleDbCommand mycomm=new OleDbCommand(sqlstr,myconn);
OleDbDataAdapter myadapter=new OleDbDataAdapter(`);
myadapter.UpdateCommand=mycomm; ///////////////
myadapter.UpdateCommand.ExecuteNonQuery();
////////////////
myconn.Close();
OleDbConnection myconn=new OleDbConnection(myconnstr);
myconn.Open();
String sqlstr="update b1 set tiaomu='44444' where id=1003";
OleDbCommand mycomm=new OleDbCommand(sqlstr,myconn);
OleDbCommand .ExecuteNonQuery();
myconn.Close();