Remove an item from XML file using C#

Question

I'm trying to write and remove items (categories) that I've stored in an XML file. I've figured out how to add using new XElement and doc.Root.Add but I don't know how to remove and item that has the same title as the input.

XML:

<?xml version="1.0" encoding="utf-8"?>
<categories>
  <category title="Horror"></category>
  <category title="Romance"></category>
  <category title="Health"></category>
  <category title="SciFi"></category>
  <category title="Programming" />
  <category title="History" />
</categories>

C#:

public static void RemoveFromCategoryXMLFile(string title)
{
    XmlDocument doc = new XmlDocument();
    doc.Load("../../DAL/XML_Categories/Categories.xml");

    XmlNode node = doc.SelectSingleNode($"/categories/category[@name='{title}']");

    if (node != null)
    {
        XmlNode parent = node.ParentNode;
        parent.RemoveChild(node);
        doc.Save("../../DAL/XML_Categories/Categories.xml");
    }
}

I want the item that matches the string title to be removed from the document. Right now nothing happens and it seems like the XmlNode returns null.

In $"/categories/category[@name='{title}']" you search for attribute @name while attribute in your XML is named title. Try with $"/categories/category[@title='{title}']" ? — An0d
– An0d, Commented Oct 30, 2019 at 7:42

Stefan · Accepted Answer · 2019-10-30 08:57:36Z

1

Using XDocument is recommended, as it is a newer class for parsing XML. With such class it's enought to use such code:

var title = "Horror";
var xml = XDocument.Load(@"path to XML");

xml.Root.Elements("category").Where(e => e.Attribute("title").Value == title).Remove();

xml.Save(@"path to output XML");

edited Oct 30, 2019 at 8:57

Stefan

6625 silver badges19 bronze badges

answered Oct 30, 2019 at 7:54

Michał Turczyn

41.2k18 gold badges58 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Remove an item from XML file using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related