XmlTextReader screen scrape get xml element content
Question:
Im trying to grab xml off a web page and get the content of one particular element.
i have a page xml.asp that outputs the following xml:
<?xml version=”1.0″?>
<?xml-stylesheet type=”text/css” href=”../quote_xml.css”?>
<quotes>
<quote>
<exchange>XYZ</exchange>
<symbol>ABC</symbol>
<description>Lorem Ipsum</description>
<lastprice>32.500</lastprice>
<timestamp>
<date>20061201</date>
<time>105500</time>
</timestamp>
</quote>
</quotes>
in my vb.net code i have this so far:
Imports System.XML
Dim xtr as New XmlTextReader(“http://www.mypage.com/xml.asp”)
xtr.MoveToContent()
xtr.MoveToElement(“lastprice”) ‘error here!
‘how can i get the lastprice element’s content i.e. 32.500 ?
‘i’m unsure of how to use the XmlTextReader’s methods, can someone point out good examples of its usage?
Solution:
From that document, I’d say the easiest option for you is:
Dim m_xmld = New XmlDocument
‘Load the Xml file
m_xmld.Load(“http://www.mypage.com/xml.asp”)
‘Get the list of name nodes
m_xmld.SelectNodes(“/family/name”)
Dim m_nodelist As Xml.XmlNodeList
m_nodelist = m_xmld.SelectNodes(“/quotes/quote”)
Dim m_node As Xml.XmlNode
‘Loop through the nodes
For Each m_node In m_nodelist
MessageBox.Show(m_node.ChildNodes.Item(3).InnerText)
Next













Comments (0)
Trackbacks - Pingbacks (0)
Leave a Reply