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

Tags: · ·
digg delicious stumbleupon technorati Google live facebook Sphinn Mixx newsvine reddit yahoomyweb
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...