How to remove a entire node from xml based on content of xml using c#

Question

I am loading the below xml using LoadXml. I need to remove the entire <site> .... </site> node based on a condition using C#.

Followed:

  XmlDocument xdoc= new XmlDocument(); 
  xdoc.LoadXml(xmlpath); 
  string xml = xdoc.InnerXml.ToString();

  if(xml.Contains("href"+"\""+ "www.google.com" +"\"")
  {
  string removenode = "";  // If href=www.google.com is present in xml then remove the  entire node. Here providing the entire <site> .. </site>
  xml.Replace(removenode,"");
  }

It is not replacing the node with null

The XML is:

 <websites>
 <site>
 <a xmlns="http://www.w3.org/1999/xhtml" href="www.google.com"> Google </a>
 </site>
 <site>
 <a xmlns="http://www.w3.org/1999/xhtml" href="www.hotmail.com"> Hotmail </a>
 </site>
 </websites>

mlorbetske · Accepted Answer · 2012-10-19 05:30:38Z

1

Here's an example that removes the site element containing any element with an href attribute containing www.google.com

using System.Diagnostics;
using System.Linq;
using System.Xml.Linq;

namespace ConsoleApplication6
{
    class Program
    {
        static void Main(string[] args)
        {
            const string frag = @" <websites>
 <site>
 <a xmlns=""http://www.w3.org/1999/xhtml"" href=""www.google.com""> Google </a>
 </site>
 <site>
 <a xmlns=""http://www.w3.org/1999/xhtml"" href=""www.hotmail.com""> Hotmail </a>
 </site>
 </websites>";

            var doc = XDocument.Parse(frag);

            //Locate all the elements that contain the attribute you're looking for
            var invalidEntries = doc.Document.Descendants().Where(x =>
            {
                //Get the href attribute from the element
                var hrefAttribute = x.Attribute("href");
                //Check to see if the attribute existed, and, if it did, if it has the value you're looking for
                return hrefAttribute != null && hrefAttribute.Value.Contains("www.google.com");
            });

            //Find the site elements that are the parents of the elements that contain bad entries
            var toRemove = invalidEntries.Select(x => x.Ancestors("site").First()).ToList();

            //For each of the site elements that should be removed, remove them
            foreach(var entry in toRemove)
            {
                entry.Remove();
            }

            Debugger.Break();
        }
    }
}

answered Oct 19, 2012 at 5:30

mlorbetske

5,6592 gold badges32 silver badges41 bronze badges

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

2 Comments

user1658567 Over a year ago

Great it worked.. But my xml was also generating

<websites xmlns="id:4457-211445-15151-151"> <site> <a xmlns="http://www.w3.org/1999/xhtml" href="www.google.com"> Google </a> </site> <site> <a xmlns="http://www.w3.org/1999/xhtml" href="www.hotmail.com"> Hotmail </a> </site> </websites>

Then it fails saying that "Sequence contains no elements"

mlorbetske Over a year ago

Replace var toRemove... with var toRemove = invalidEntries.Select(x => x.Ancestors().First(y => y.Name.LocalName == "site")).ToList(); it's the namespace that caused the issue

Milind Thakkar · Accepted Answer · 2012-10-19 05:26:16Z

0

I think you need to use proper XML and XPath for this. Try following

XmlNodeList nl = xDoc.DocumentElement.SelectNodes("Site");

foreach(XmlNode n in nl)
{
    if(n.SelectSingleNode("a").Attributes("href").Value == "www.google.com")
    {
        n.ParentNode.RemoveChild(n);
    }

}

Hope that helps.

Milind

answered Oct 19, 2012 at 5:26

Milind Thakkar

9802 gold badges13 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to remove a entire node from xml based on content of xml using c#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related