萧萧编程随笔

1.xml文件内容

<?xml version="1.0" encoding="GB2312"?>
<Test>
<Test UID="4" UName="sa" Birthday="2007-09-17 18:52:00"/>
<Test UID="6" UName="s2" Birthday="2007-09-17 18:53:00"/>
<Test UID="9" UName="sa2" Birthday="2007-09-18  18:54:00"/>
</Test>

C#的操作源码：

 private void button1_Click(object sender, System.EventArgs e)
  {
   try
   {
                SqlConnection conn=new SqlConnection("server=.;database=Test;uid=sa;pwd=");
          string sql="select * from Test";
          SqlDataAdapter da=new SqlDataAdapter(sql,conn);
          DataSet ds=new DataSet();

    da.Fill(ds,"Test");
    
  
    DataSet ds2=new DataSet();
    ds2.ReadXml(@"c:\1.xml");
    DataTable dt=ds2.Tables[0];

    
    ds.Merge(dt,true,MissingSchemaAction.Ignore);//关键所在，合并两个ds到一张表中
    this.dataGrid1.DataSource=ds.Tables[0];
    SqlCommandBuilder sb=new SqlCommandBuilder(da);
    if(ds.Tables["Test"].GetChanges()==null)
    {
     da.Update(ds,"Test");
     ds.AcceptChanges();//真正的更新数据库 调用 ds.RejectChanges() 取消更新。
     MessageBox.Show("更新成功！");
    }
    else
     MessageBox.Show("更新失败！");
    

   }
   catch(Exception ex)
   {
    MessageBox.Show(ex.Message);
   }
  }