为什么保存不了记录?
我用dataset.merge记录合并,并更新本地数据库,为什么不行?
private void menuItem_receive_Click(object sender, System.EventArgs e)
{
GmServices.LnService ln=new RnasServer.GmServices.LnService();
updateds=ln.Order_Update_gm();
if(updateds!=null)
{
update_database(updateds);
}
}
private void update_database(DataSet dsOrder)
{
string strConn=@"server=APP-SERVER;database=CustomerService;user id=sa;pwd=4H34M1X;";
SqlConnection CN=new SqlConnection(strConn);
try
{
CN.Open();
this.adp=new SqlDataAdapter("select * from receive ",CN);
this.adp.Fill(ds,"order");
ds.Merge(dsOrder);
SqlCommandBuilder sqlcb=new SqlCommandBuilder(adp);
this.adp.Update(ds,"order");
this.ds.AcceptChanges();
//test
// for(int j=0;j<=7;j++)
// {
// for(int i=0;i<=10;i++)
// {
// string m=ds.Tables[0].Rows[j][i].ToString();
// MessageBox.Show(m);
// }
// }
}
catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
CN.Close();
}
}
不出错,但数据库没有新记录合并进去!