How to remove XML node by attribute

Question

XML

<WorkTable>
    <Days>
      <Day id="0" name="Monday"/>
      <Day id="1" name="Tuesday"/>
      <Day id="2" name="Wednesday"/>
      <Day id="3" name="Thursday" />
      <Day id="4" name="Friday"/>
      <Day id="5" name="Saturday"/>
      <Day id="6" name="Sunday"/>
    </Days>
    <SpecialDays>
      <Day date="22.07.2015"/>
      <Day date="24.07.2015"/>
    </SpecialDays>
</WorkTable>

This code doesn't remove the node from xml. Could you help me to find problem?

XmlDocument doc = new XmlDocument();
doc.Load(localXMLpath + xmlFileName);
XmlNode delNode= doc.SelectSingleNode("/WorkTable/SpecialDays/Day[@date='24.07.2015']");
delNode.ParentNode.RemoveChild(delNode);
doc.Save(localXMLpath + xmlFileName);

Answer 1

This should works:

XDocument xdoc = XDocument.Load(filename);
xdoc.Element("WorkTable").Element("SpecialDays").Elements("Day")
     .Where(x => (string)x.Attribute("date") == "24.07.2015")
     .Remove();
xdoc.Save(filename);

Answer 2

Your code works OK, the problem is that you're trying to overwrite the file you've read the data from.

See this answer C# : the close method of Xml.Load(file)