Ignoring parent node in XML using XMLReader in C#

Question

I have an XML file from which I have to extract some specific nodes and put them in a SQL table.

I am using XmlReader and have switch case on XmlReader.Name

Here is just a sample one with very few nodes just for explanation.

<products>
   <product>
       <description>Nothing</description>
       <cost>$34.78</cost>
       <inventory>166</inventory>
   </product>
   <product>
       <description>Nike Cap 17893</description>
       <cost>$29.99</cost>
       <inventory>54</inventory>
   </product>
</products>

The idea is if there is Nothing in description node, I should ignore the entire product and move to the next product.

I wanted to use XmlReader.Skip() in that case but it seems it only skips the chidren nodes but the parents nodes.

Just wondering if C# provides any method to ignore parent node?

@bluepiranha: That still sounds like you should easily be able to load it into memory, which would make it much easier to handle than with XmlReader. — Jon Skeet
– Jon Skeet, Commented Jul 25, 2014 at 14:28
@JonSkeet Pardon my noviceness, but when you say load it into memory, what C# API class do you suggest me to read the XML file? — blue piranha
– blue piranha, Commented Jul 25, 2014 at 14:30
Use LINQ to XML, as suggested by Selman22, e.g. XDocument doc = XDocument.Load("products.xml") — Jon Skeet
– Jon Skeet, Commented Jul 25, 2014 at 14:31

Awesomni.Codes · Accepted Answer · 2014-07-25 15:07:32Z

1

With Linq To Xml you could easily ignore all Elements that are "Nothing" and just process the other elements.

Here is quick Example.

XElement root = XElement.Load("file.xml");
IEnumerable<XElement> productsWithoutNothing = from product in root.Elements("product")
                                               where (string)product.Element("description") != "Nothing"
                                               select product;

answered Jul 25, 2014 at 15:07

Awesomni.Codes

2,4461 gold badge27 silver badges28 bronze badges

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

Comments

Neons · Accepted Answer · 2014-07-25 14:32:56Z

0

I think it would be much easier if you use XSL to filter the nodes.

Step 1: Use XSL to get a list of (parent) nodes which has description

Step 2: Loop through this filtered set

answered Jul 25, 2014 at 14:32

Neons

1

Collectives™ on Stack Overflow

Ignoring parent node in XML using XMLReader in C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related