dataset更新数据库简单问题，来看看

Question

try
            {
                DataSet ds = new DataSet();
                 SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;initial catalog=Fin;Integrated Security=True;User id=;Password=");
                con.Open();                SqlDataAdapter da1 = new SqlDataAdapter("select * from customerschange", con);
                da1.Fill(ds, "customers");               DataSet dsget = new DataSet();
                SqlConnection con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;initial catalog=Fin;Integrated Security=True;User id=;Password=");
                con1.Open();
               SqlDataAdapter da = new SqlDataAdapter("select * from customers", con1);
                SqlCommandBuilder cb=new SqlCommandBuilder(da);
                da.Fill(dsget, "customers");
                
                dsget.Merge(ds);
                dsget.AcceptChanges();                 da.Update(dsget,"customers");
                           }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

Answer 1

try
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;initial catalog=Fin;Integrated Security=True;User id=;Password=");
con.Open();SqlDataAdapter da1 = new SqlDataAdapter("select * from customerschange", con);
da1.Fill(ds, "customers");DataSet dsget = new DataSet();
SqlConnection con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;initial catalog=Fin;Integrated Security=True;User id=;Password=");
//con1.Open();不需要
SqlDataAdapter da = new SqlDataAdapter("select * from customers", con1);
SqlCommandBuilder cb=new SqlCommandBuilder(da);
da.Fill(dsget, "customers");dsget.Merge(ds);
//dsget.AcceptChanges();//不需要，执行就无法数据更新。da.Update(dsget,"customers");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

Answer 2

同意楼上的意见
应该无法更新数据库吧，两个dataset都是从数据库里取的，所以里面的datarow的datarowstate都是unchange，所以合并能够成功，但是都是unchange的状态，所以就不会去更新数据库。那么想把合并的dataset更行数据库要怎么做才行