XML和DataSet转换

用.NET可以方便的操作XML,当做数据源

*当XML转到DataSet的时候会遵循如下几个原则
*具有属性的元素和具有自节点的元素会变成表
*重复的元素会变成列

这里使用GridView绑定
  XML:

<?xml version="1.0" standalone="yes"?>
<family>
  <p relation="myfather">
    <name>安</name>
    <sex>man</sex>
    <age>60</age>
  </p>
  <p relation="mymather">
    <name>宝</name>
    <sex>women</sex>
    <age>55</age>
  </p>
</family>

 读取:

 protected void Page_Load(object sender, EventArgs e)
    {
        bind();
    }
  protected void bind()
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("../people.xml"));
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();

        Session["ds"] = ds;

    }

添加:

protected void Button1_Click(object sender, EventArgs e)
    ...{
       
     DataSet ds = (DataSet)Session["ds"];
        string name = this.TextBox1.Text.ToString();
        string age = this.TextBox2.Text.ToString();
        string sex = this.TextBox3.Text.ToString();
        string relation = this.RadioButtonList1.SelectedValue.ToString();

        DataRow dr = ds.Tables[0].NewRow();

        dr["relation"] = relation;
        dr["age"] = age;
        dr["sex"] = sex;
        dr["name"] = name;
        ds.Tables[0].Rows.Add(dr);

     Session["ds"] = ds;
        ds.WriteXml(Server.MapPath("../people.xml")); 
     bind();
    }

删除:

  protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        DataSet ds = (DataSet)Session["ds"];
        ds.Tables[0].Rows.Remove(ds.Tables[0].Rows[e.RowIndex]);
        Session["ds"] = ds;
        ds.WriteXml(Server.MapPath("../people.xml"));
        bind();
    }

修改: