How to get the String of a XML node in C#

Question

enter code herein the XML document :

<foo>
  <bar><para> test </para> </bar>
  <bar>text</bar>
  <bar>stackoverflow</bar>
</foo>

I am trying to parse it and only get the Strings in bar; by using this way:

[function where node is the foo]

foreach (XmlNode subNode in node.ChildNodes)
{

 if (subNode.Name == "bar")
 {
    if (!String.IsNullOrWhiteSpace(subNode.InnerText))
     Debug.WriteLine(subNode.Name + " - " subNode.InnerText);
 }

}

However it gives me test

Thanks

I have some code that actually does do this, if you are interested I can post it. I created a web application that will read an input file from NIST and update the corresponding local database with their latest vulnerability information. The source file from them is XML so I have to parse out their data and populate my database fields with their information. — bbcompent1
– bbcompent1, Commented May 15, 2017 at 14:10
without XPath (so XmlDocument or XmlReader?! Why would you want to discount ways to parse the XML correctly? — Liam
– Liam, Commented May 15, 2017 at 14:10
Possible duplicate of How to read a particular node from xml in C#? — Liam
– Liam, Commented May 15, 2017 at 14:11

Glorfindel · Accepted Answer · 2022-07-16 08:07:23Z

1

This is what you are looking for (EDITTED based on you updated question)

XDocument doc = XDocument.Load(path to your xml file);
XNamespace ns = "http://docbook.org/ns/docbook";

var result = doc.Root.Descendants(ns + "para")
                     .Where(x => x.FirstNode.NodeType == System.Xml.XmlNodeType.Text)
                     .Select(x => x.Value)
                     .ToList();

In your updated xml I see you are using a namespace so the name of your node is not para but it's theNameSpace + "para". The namespace is defined in the first line of your xml file. Also you can see this sample too.

edited Jul 16, 2022 at 8:07

Glorfindel

22.8k13 gold badges97 silver badges124 bronze badges

answered May 15, 2017 at 14:20

Hossein Narimani Rad

32.7k19 gold badges92 silver badges122 bronze badges

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

3 Comments

Xavier C. Over a year ago

Thanks for your help dude, I don't know why it doesn't work I edited my first post with the true structure but I thought my first should have work sorry.

Hossein Narimani Rad Over a year ago

Your xml file is not a valid one.

Hossein Narimani Rad Over a year ago

Your xml file is not valid yet. if you update it I can help you. otherwise you can get the whole idea from the answer.

jdweng · Accepted Answer · 2017-05-15 14:25:17Z

0

Do you want "test"? Try following :

            string input =
                "<foo>" +
                  "<bar><para> test </para> </bar>" +
                  "<bar>text</bar>" +
                  "<bar>stackoverflow</bar>" +
                "</foo>";


            XDocument doc = XDocument.Parse(input);

            List<string> bars = doc.Descendants("bar").Where(x => x.NextNode != null).Select(x => (string)((XElement)x.NextNode)).ToList();

edited May 15, 2017 at 14:25

answered May 15, 2017 at 14:17

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

1 Comment

Xavier C. Over a year ago

I don't want test because it's not in bar but in para, I edited my first post. Sorry if it was confuse

Collectives™ on Stack Overflow

How to get the String of a XML node in C#

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related