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