reading a XML file

connect2sandep · December 13th, 2006, 02:06 PM

well, i read a lot about xml but never used it, and i need help regarding a problem. Here is some XML in string form:
<order>
<transactiondetails>
<oid>1a6493b4-7cfe-4c33-bdc1-238bb4af7fe0</oid>
</transactiondetails>
<payment>
<chargetotal>40.00</chargetotal>
</payment>
<billing>
<name>Sandeep Pradhananga</name>
<company>NA</company>
<address2>KTM, </address2>
<state>MD</state>
<zip>56536</zip>
<address1>KTM, </address1>
<city>KTM</city>
</billing>
<orderoptions>
<ordertype>SALE</ordertype>
<result>LIVE</result>
</orderoptions>
<creditcard>
<cvmvalue>123</cvmvalue>
<cvmindicator>provided</cvmindicator>
<cardnumber>4111-1111-1111-1111</cardnumber>
<cardexpyear>08</cardexpyear>
<cardexpmonth>01</cardexpmonth>
</creditcard>
<merchantinfo>
<configfile>1001158260</configfile>
</merchantinfo>
</order>

assuming the xml is in a string object how to parse the value corresponding to 'chargetotal'using C#.
Please Help!

joefawcett · December 14th, 2006, 04:50 AM

There are a few different ways, the easiest is probably to load the string into an XPathDocument via a StringReader, if the XML is a file you can use a StreamReader instead. Then use the XPathNavigator to select the desired value.
The code for a console application is shown here:

Code:

using System;
using System.IO;
using System.Text;
using System.Xml;
using System.Xml.XPath;

namespace XmlFromString
{
  class Program
  {
    static void Main(string[] args)
    {
      string xml = "<order/>"; //Full order document to go here
      XPathDocument doc = new XPathDocument(new StringReader(xml));
      string xpath = "/*/payment/chargetotal";
      XPathNavigator nav = doc.CreateNavigator();
      XPathNavigator node = nav.SelectSingleNode(xpath);
      Console.WriteLine("{0}: {1}", node.Name, node.InnerXml);
      Console.ReadLine();
    }
  }
}

--

Joe (Microsoft MVP - XML)