delete nodes in XML

[Shinobi]

I am trying to delete a node in xml. Nothing is worked correctly.
Here is XML

<cat>
  <category>
    <id>1</id>
    <name>Architecture</name>
  </category>
  <category>
    <id>2</id>
    <name>Education</name>
  </category>
 

I tried this code. But not worked.

XmlDocument xdoc = new XmlDocument();
        xdoc.Load(Server.MapPath("main.xml"));
        XmlNodeList nodes = xdoc.GetElementsByTagName("category");
        foreach (XmlNode node in nodes)
        {
 
            if (node["id"].InnerText == id)
            {
                node.ParentNode.ParentNode.RemoveChild(node.ParentNode);
            }
 
        }

Please help me.

Thanks.

[nukefusion]

You look like you've got too many ParentNode's in that last bit. Try:

XmlDocument xdoc = new XmlDocument();
xdoc.Load(Server.MapPath("main.xml"));
XmlNodeList nodes = xdoc.GetElementsByTagName("category");
foreach (XmlNode node in nodes)
{
    if (node["id"].InnerText == "1")
    {
        node.ParentNode.RemoveChild(node);
    }
}
 

A slightly better implementation might be to use XPath to find the target node, rather than looping through lots of nodes. Something like:

          XmlDocument xdoc = new XmlDocument();
            xdoc.Load(Server.MapPath("main.xml"));
            XmlNode childToDelete = xdoc.SelectSingleNode("/cat/category[id=\"1\"]");
            childToDelete.ParentNode.RemoveChild(childToDelete);
 

[Shinobi]

Thanks. Yhank u so much

[PRR]

@Shinobi
In addition to what nukefusion explained... you could also use a dataset...Dataset Read Write XML