Retrieving XML data

[gpsushil]

IXMLDOMDocument class is used to load the XML file and it's working fine. But what I want do it get the elements from XML file and add it to list view control.

Using pXMLDom->get_text(&bstr);
I'm getting all the elements but i want them in tokens so that i can add them in list view.

[ventsyv]

Try XPath query. For more info on XPath : www.w3schools.com
Something like this should work:

Code: Select all

pXMLDom->SelectNodes("//myNode");


[gpsushil]

I saw pSMLDom->SelectNodes("//myNode",pNodeList);

I couldnot get values for the individual node.

My XML looks like this:

Code: Select all

<?xml version="1.0" encoding="ISO-8859-1"?>
<CATALOG>
   <CD>
      <TITLE>Empire Burlesque</TITLE>
      <ARTIST>Bob Dylan</ARTIST>
      <COUNTRY>USA</COUNTRY>
      <COMPANY>Columbia</COMPANY>
      <PRICE>10.90</PRICE>
      <YEAR>1985</YEAR>
   </CD>
   <CD>
      <TITLE>Hide your heart</TITLE>
      <ARTIST>Bonnie Tyler</ARTIST>
      <COUNTRY>UK</COUNTRY>
      <COMPANY>CBS Records</COMPANY>
      <PRICE>9.90</PRICE>
      <YEAR>1988</YEAR>
   </CD>
   <CD>
      <TITLE>Hide your face</TITLE>
      <ARTIST>Bonnie Gupta</ARTIST>
      <COUNTRY>USA</COUNTRY>
      <COMPANY>MGM Records</COMPANY>
      <PRICE>19.90</PRICE>
      <YEAR>1998</YEAR>
   </CD>
</CATALOG>

From above XML file I want in one query TITLE of the book and next ARTIST and so on. How is it possible ?

[ventsyv]

Sure is.

Code: Select all

SelectNodes("//CD", pNodeList)
foreach (Node myNode in pNodelist)
{
   myNode->SelectSingleNode("//title", titleNode);
   myNode->SelectSingleNode("//artist", artistNode);

   titleNode.DoStuff();
   artistNode.DoStuff();
}