还是DataSet更新问题

Question

你要先写一个UpdataCommand的DataCommand的对象。
再调用XX=laDataSet.getChanges();返回更改过的记录集。
再调用SqlDataAdapter.Update(XX)不是主键的问题来的！！

Answer 1

SqlConnction conn=new SqlConnction("server=localhost;database=employee;uid=sa;pwd=")
       SqlCommand comm=conn.CreatConnection;
       SqlDataAdapter adp=new SqlDataAdapter();
       adp.comm="Select  * from employee";
       adp.Update=comm;
       DataSet ds=new DataSet();
   conn.Open();
         adp.Fill(ds,"employee");
   conn.Close();
    在OleDb中.
  OleDbConnection myConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+@"\mctest.mdb");
 OleDbCommand myComm=new OleDbCommand();
    myConn.Open();
    OleDbDataAdapter myAdapter= new OleDbDataAdapter("SELECT * from wenzhang",myConn);
     myAdapter.CommandText="";
     myAdapter.update=comm;
    OleDbCommandBuilder myBuilder=new OleDbCommandBuilder(myAdapter);