学步园

string everyConn = Common.CommonUtility.GetEveryConn ();
//   EmpResource mpEvery = new EmpResource(everyConn);
//   DataSet dsE= mpEvery.mpResourceList ();
//   DataTable dtE=dsE.Tables[0];
   DataSet dsE = new DataSet();
   System.Data.SqlClient.SqlConnection Econn = new SqlConnection(everyConn);
   
   string strSql = " select * from empResource";
   Econn.Open();
   //SqlCommand everyCmd = new SqlCommand(strSql,Econn);
   //string srcTable ="empResource";
   SqlDataAdapter sqlAdapter = new SqlDataAdapter(strSql,Econn);

   SqlCommandBuilder scb = new SqlCommandBuilder(sqlAdapter);
   //everyCmd.ExecuteNonQuery();
   sqlAdapter.Fill(dsE,"empResource");

   DataTable dtE=dsE.Tables["empResource"];
   dtE.PrimaryKey = new DataColumn[]{dtE.Columns["mpId"]} ;

   
   EmpResource mp = new EmpResource(conStr);
   DataSet ds = mp.mpResourceByMpId (pubMpId);
   DataTable dt = ds.Tables[0];
   int rowCount = dt.Rows.Count;
   if(rowCount>0)
   {
    for (int i=0;i<rowCount;i++)
    {
     if(dtE.Select("mpId="+dt.Rows[i]["mpId"].ToString())!=null)
     {
      dtE.ImportRow (dt.Rows[i]);
      dtE.AcceptChanges ();
      

     }
     
    }
   }
   
   dsE.Merge(ds);
//   foreach(DataRow dr in dsE.Tables[0].Rows)
//   {
//    Response.Write (dr["mpId"].ToString()+"|");
//    Response.Write (dr["mpName"].ToString()+"#");
//   }
   //Response.Write (dsE.HasChanges());
   sqlAdapter.Update(dsE,"empResource");
   
   //dsE.AcceptChanges();
   Econn.Dispose();

不报错，可是就是更新不了数据库

而且dsE.HasChanges()一直是flase