利用DataSet读写XML

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System .Data .SqlClient ;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    string strSql = "server=192.168.1.105;uid=sa;pwd=zy;database=ccdc_database";
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con=new SqlConnection (strSql);
        SqlCommand cmd =new SqlCommand ("select * from tbccConsoleUser",con);
        SqlDataAdapter da=new SqlDataAdapter (cmd );
        DataSet ds=new DataSet ("News");
        da.Fill (ds,"Users");

        ds.WriteXml(Server.MapPath(".") + "/News.xml");

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath(".") + "/News.xml");
        DataTable dt = ds.Tables["Users"];

        int count = dt.Rows.Count;
        for (int i = 0; i < count; i++)
        {
            if (!dt.Rows[i]["UName"].ToString ().Equals (""))
            {
                dt.Rows[i]["UName"] = "这是图片新的路径";
            }
        }
        ds.AcceptChanges();
        ds.WriteXml(Server.MapPath(".") + "/News.xml");
  
    }
}