如何在XML节点中选择子节点

Question

我想删除选定的行并更新XML文件，然后加载带有更新的数据的网格视图。调试时，我将获得Nodelist的零值。

这是我的XML文件

<?xml version="1.0" encoding="utf-8" ?>
<PERSONES>
  <person>
    <name>Dilan Perera</name>
    <age>22</age>
  </person>
  <person>
    <name>Thusitha Badde</name>
    <age>24</age>
  </person>
</PERSONES>

这是按钮点击事件。问题是我得到Nodelist的无效

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{      
    GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
    string age = row.Cells[2].Text.Trim(); // i get correct value for age here
    XmlDocument doc2 = new XmlDocument();
    doc2.Load(Server.MapPath("names.xml")); 
    XmlNode nodeList = doc2.SelectSingleNode(string.Format("PERSONES/person[@age='{0}']", age));
    doc2.DocumentElement.RemoveChild(nodeList);
    doc2.Save(Server.MapPath("names.xml"));
    getdata();   
}

Answer 1

xpath查询不正确， @表示属性，因此在年龄检查中删除 @，然后将过滤元素。

   protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
   {      
       GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
       string age = row.Cells[2].Text.Trim(); // i get correct value for age here
       XmlDocument doc2 = new XmlDocument();
       doc2.Load(Server.MapPath("names.xml")); 
       XmlNode nodeList = doc2.SelectSingleNode(string.Format("PERSONES/person[age='{0}']", age));
       doc2.DocumentElement.RemoveChild(nodeList);
       doc2.Save(Server.MapPath("names.xml"));
       getdata();   
   }

我刚刚测试了它，它起作用。

Answer 2

XmlDocument doc2 = new XmlDocument();
doc2.Load(Server.MapPath("names.xml")); 
XmlNode ageNode = doc2.SelectSingleNode(string.Format("//PERSONES/person/age[text() = '{0}']", age));
if (ageNode != null)
{
    var personNode = ageNode.ParentNode;
    doc2.DocumentElement.RemoveChild(personNode);
    doc2.Save(Server.MapPath("names.xml"));
}