How can i get xml node value from string

Question

I am trying to get XML values from the following XML node:

<StockQuotes>
  <Stock>
    <Symbol>LLOY.L</Symbol>
    <Last>76.27</Last>
    <Date>8/29/2014</Date>
  </Stock>
</StockQuotes>

Here is my code:

XmlDocument quoteXML = new XmlDocument();

string strData = myXMLfile;
quoteXML.LoadXml(strData);
XmlNode nodes = quoteXML.SelectSingleNode("StockQuotes/Stock/Last/Date");
string strPrice = nodes["Last"].InnerText;
string strDate = nodes["Date"].InnerText;

Response.Write( strPrice + strDate );

I am getting the error:

Object reference not set to an instance of an object.

when I write the whole string strData to the view I get all of the XML so I know the file is valid.

Please be more relevant and as @PolymorphicPotato said, tell us what language/plateform are you in! — tmarwen, Aug 31 '14 at 10:07
Error raised is due to an object being used before it has been instantiated. Do verify your objects on debugging mode! — Nadeem_MK, Aug 31 '14 at 11:53
Nadeem, are you guessing mate. If you read the post properly it tells you that the XML can be written to the view in full. If you don't have a resolution, why are you replying? — user3746002, Aug 31 '14 at 13:35

score 0 · Answer 1 · edited May 23 '17 at 12:12

SOURCE OF THE PROBLEM:

quoteXML.SelectSingleNode("StockQuotes/Stock/Last/Date"); SelectSingleNode call will return representation of <Date>8/29/2014</Date>,

But you try to access subnodes ["Last"] and ["Date"], that are not child nodes of <Date>8/29/2014</Date> and taking into account that indexer returns:

The first XmlElement that matches the specified name. It returns a null reference (Nothing in Visual Basic) if there is no match.

nodes["Last"] and nodes["Base"] will be both null, resulting in NullReferenceException on .InnerText property access.

SOLUTION:

Use

XmlNode nodes = quoteXML.SelectSingleNode("StockQuotes/Stock");

to access Stock node instead.

score 0 · Answer 2 · answered Sep 16 '14 at 15:24

The issue was with special charchters in the XML feed. I have resolved the issue and used:

'string strData = WebService.GetDate(); // returns xml as string
            string decoded = WebUtility.HtmlDecode(strData); quoteXML.LoadXml(decoded); 

            XmlDocument xml = new XmlDocument();
            xml.LoadXml(decoded);
            XmlNodeList xnList = xml.SelectNodes("/StockQuotes/Stock");
            foreach (XmlNode xn in xnList)
            {
                strQuote = xn["Last"].InnerText;
            }'

How can i get xml node value from string

2 Answers2