Getting values from xml file using C#

Question

I'm pretty new to xml and I don't know how to read/get values from xml file below:

<?xml version="1.0" encoding="utf-8" ?>
<Jeopardy>
  <category name = 'People in Computing'>
<first points = '100' answer = 'Alan Turing'>Known as the questioner of the human   mind, this man is known for helping tell humans and computers apart.</first>
<second points = '200' answer = 'Grace Hopper'>This female pioneer of the COBOL computer programming language was an Admiral in the US Navy.</second>
<third points = '300' answer = 'Tim Berners-Lee'>Called the father of the world wide web, this man is the director of the W3C.</third>
<fourth points = '400' answer = 'Lawrence Lessig'>An American academic and political activist who founded the Creative Commons, this man lobbies for reduced legal restrictions on copyrights and trademarks in the technology sector.</fourth>
<fifth points = '500' answer = 'Ada Lovelace'>This woman, known as the world's first computer programmer was also a Countess.</fifth>
  </category>
</Jeopardy>

Sorry for the terrible formatting, can't get it right.

First of all, I tried to load this file in XDocument results in a "Non-white space cannot be added to content" exception, but it didn't occur if loaded into XmlDocument.

My code to attempt to get the name value:

        string fileName = @"C:\Users\Kara\documents\visual studio 2010\Projects\Final Project\Final Project\Jeopardy.xml";

        XmlDocument doc = new XmlDocument();

        doc.Load(fileName);

        List<string> categories = new List<string>();

        XmlNodeList nList = doc.SelectNodes("/category/name");

        foreach (XmlNode node in nList)
        {
            categories.Add(node.ToString());
        }

Sadly while debugging the nList has a count of zero and I cannot figure out why. I've tried looking at a ton of questions already on here and tutorials elsewhere and I'm just getting frustrated. How in the world do I get the values out of name and other nodes? Can someone explain this? And perhaps why I get the non-white space error with XDocument?

aquinas · Accepted Answer · 2013-01-08 03:47:21Z

7

doc.SelectNodes("/category/name")

You're not finding any nodes because 1) the first node is Jeopardy, not category and 2) name is an attribute of category not a child element.

Try: doc.SelectNodes("/Jeopardy/category/@name")

Like this:

foreach (XmlNode node in nList) {
  categories.Add(node.Value);
}

edited Jan 8, 2013 at 3:47

answered Jan 8, 2013 at 3:36

aquinas

23.9k5 gold badges60 silver badges82 bronze badges

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

2 Comments

Kefkamaydie Over a year ago

Oh my thank you so much! that (node.Attributes["name"].Value works like a charm!

aquinas Over a year ago

I actually edited the answer to make it a little simpler so that you directly select the attribute. I think it's clearer now and closer to what you had.

itzmebibin · Accepted Answer · 2015-05-18 13:57:54Z

4

Make sure that the encoding of the file matches the encoding expected by your document loading method. Usually UTF8 is the prefered encoding of XML files.

As noted above, you can use:

doc.SelectNodes("/Jeopardy/category/name");

or

doc.SelectNodes("//category/name");

or

doc.SelectNodes("//name");

edited May 18, 2015 at 13:57

itzmebibin

9,4479 gold badges52 silver badges63 bronze badges

answered Jan 8, 2013 at 3:39

Kenneth Ellested

612 bronze badges

Comments

Prasad Joshi · Accepted Answer · 2016-07-29 07:05:03Z

1

You need to open XML document

 XmlDocument _document = new XmlDocument();
    byte[] bytes = File.ReadAllBytes(filePath);
   string xml = Encoding.UTF8.GetString(bytes);
    try
    {
    _document.LoadXml(xml);
    }
    catch (XmlException e)
    {
    //exception handling
    }                  

    var doc = (XmlDocument)_document.CloneNode(true);

    XmlNode node = doc.GetElementsByTagName("your child node name");

Once you get your node then you can do necessary thing with it

answered Jul 29, 2016 at 7:05

Prasad Joshi

4694 silver badges12 bronze badges

Collectives™ on Stack Overflow

Getting values from xml file using C#

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related