Larry,
i've added the external loop to loop through the cities in the XML file, and
in one example, it finds the nine cities but it displays the first one nine
times. I'm sure its something minor but i just cant seem to figure it out.
here is the XML, and source code below:
--------------------XML---------------------
<?xml version="1.0" encoding="utf-8"?>
<weatherFeed>
<!--Current Weather Conditions - taken from CNN.com Weather website.
(16/01/2004 12:43:26)-->
<CurrentConditi ons>
<!--URL: http://weather.cnn.com/weather/forecast.jsp?lo cCode=TNCA-->
<country>Arub a</country>
<city>Oranjesta d</city>
<weatherImageUR L>
http://i.cnn.net/cnn/.element/img/1..../lrg/partly.su
nny.gif</weatherImageURL >
<celcius>25°C </celcius>
<farenheit>77°F </farenheit>
<description>Pa rtly Sunny</description>
<relativeHumidi ty>88%</relativeHumidit y>
<wind>E at 2 mph (3 km/h)</wind>
<sunrise>7:05 AM</sunrise>
<sunset>6:34 PM</sunset>
<barometricPres sure>29.89Hg (F)</barometricPress ure>
<lastUpdated> 16/01/2004 12:43:38</lastUpdated>
<!--5 Day Weather Forecast-->
<fiveDayForecas t>
<Day1>
<day>Friday</day>
<highCelcius>30 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 86°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>htt p://i.cnn.net/cnn/.element/img/1.0/weather/med/showers.gif</ima
geURL>
</Day1>
<Day2>
<day>Saturday </day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day2>
<Day3>
<day>Sunday</day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day3>
<Day4>
<day>Monday</day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 6°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day4>
<Day5>
<day>Tuesday</day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day5>
</fiveDayForecast >
</CurrentConditio ns>
<CurrentConditi ons>
<!--URL: http://weather.cnn.com/weather/forecast.jsp?lo cCode=NUSN-->
<country>Arub a</country>
<city>St. Nicolaas</city>
<weatherImageUR L>
http://i.cnn.net/cnn/.element/img/1..../lrg/partly.su
nny.gif</weatherImageURL >
<celcius>25°C </celcius>
<farenheit>77°F </farenheit>
<description>Pa rtly Sunny</description>
<relativeHumidi ty>88%</relativeHumidit y>
<wind>E at 2 mph (3 km/h)</wind>
<sunrise>7:05 AM</sunrise>
<sunset>6:34 PM</sunset>
<barometricPres sure>29.89Hg (F)</barometricPress ure>
<lastUpdated> 16/01/2004 12:44:10</lastUpdated>
<!--5 Day Weather Forecast-->
<fiveDayForecas t>
<Day1>
<day>Friday</day>
<highCelcius>30 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 86°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>htt p://i.cnn.net/cnn/.element/img/1.0/weather/med/showers.gif</ima
geURL>
</Day1>
<Day2>
<day>Saturday </day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day2>
<Day3>
<day>Sunday</day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day3>
<Day4>
<day>Monday</day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 6°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day4>
<Day5>
<day>Tuesday</day>
<highCelcius>29 °C</highCelcius>
<lowCelcius>24° C</lowCelcius>
<highFarenheit> 85°F</highFarenheit>
<lowFarenheit>7 5°F</lowFarenheit>
<imageURL>
http://i.cnn.net/cnn/.element/img/1....rtly.cloudy.gi
f</imageURL>
</Day5>
</fiveDayForecast >
</CurrentConditio ns>
</weatherFeed>
----------------SOURCE CODE-----------------
Dim xDoc As New XmlDocument
Dim xe_weatherFeed As XmlElement
Dim xe_city As XmlNode
Dim xe_currentCondi tions As XmlElement
Dim xe_currentCondi tionsChild As XmlNode
Dim xe_fiveDayForec ast As XmlElement
Dim xe_fiveDayForec astDay As XmlElement
Dim xe_fiveDayForec astDayDetails As XmlNode
Try
Dim a() As String
Dim al As New ArrayList
Dim i As Integer
xDoc.Load(strBa seURL & "weather/" &
Request.QuerySt ring("countryID ") & ".xml")
xe_weatherFeed = xDoc.SelectSing leNode("/weatherFeed")
xe_city = xDoc.SelectSing leNode("/weatherFeed/city")
xe_currentCondi tions =
xDoc.SelectSing leNode("/weatherFeed/city/currentConditio ns")
xe_fiveDayForec ast =
xDoc.SelectSing leNode("/weatherFeed/city/fiveDayForecast ")
For Each xe_city In xe_weatherFeed. ChildNodes
If xe_city.NodeTyp e = XmlNodeType.Ele ment Then
ReDim Preserve a(41)
i = 0
For Each xe_currentCondi tionsChild In
xe_currentCondi tions.ChildNode s
If xe_currentCondi tionsChild.Node Type =
XmlNodeType.Ele ment Then
a(i) = xe_currentCondi tionsChild.Inne rText
i += 1
End If
Next
For Each xe_fiveDayForec astDay In xe_fiveDayForec ast
For Each xe_fiveDayForec astDayDetails In
xe_fiveDayForec astDay
If xe_fiveDayForec astDayDetails.N odeType =
XmlNodeType.Ele ment Then
a(i) =
xe_fiveDayForec astDayDetails.I nnerText
i += 1
End If
Next
Next
al.Add(a)
End If
Next
weatherRepeater .DataSource = al
weatherRepeater .DataBind()
Catch err As Exception
Response.Write( "<br><font color=red><b>" & err.Message &
"</b></font>")
Finally
xDoc = Nothing
End Try
thanks again for your help.
regards,
Paul.
"Larry Rubin" <ru****@aeltus. com> wrote in message
news:u0******** ******@tk2msftn gp13.phx.gbl...
Paul, I'm glad the example will be of help to you.
In the case of the <CurrentConditi ons> tag appearing multiple times, you
would establish a For Each loop on a xe_WeatherFeed element.
For example, xe_WeatherFeed = myXMLDoc.Select SingleNode("/weatherFeed")
' This loop would be the outermost loop in the code example below.
For Each xe_CurrentCondi tion in xeWeatherFeed.C hildNodes
' The 1st time through would be for your first city, the 2nd time
through would be your 2nd city... etc.
Next
Larry R
"Paul M" <mi******@hotma il.com> wrote in message
news:eX******** ******@TK2MSFTN GP10.phx.gbl... actually, just one more thing.
the CurrentConditio ns tag, may appear multiple times depending on how
many cities there are for that country.
Is this also easy to implement?
thanks again for your valuable help.
Paul.
"Larry Rubin" <ru****@aeltus. com> wrote in message
news:eA******** ******@TK2MSFTN GP11.phx.gbl... Hi Paul,
The following is one way (of many ways) you can get at the elements in
your document. I find this way easy to follow and I'm sure there are more
elegant ways of accomplishing the same end result.
1. You can use the xmldocument class to load in your xml document.
This class exists in system in the system.xml namespace.
e.g. Dim myXMLDoc as new xmldocument()
Try
myXMLDoc.load(< path and filename of your xml document>
Catch
....
2. Declare the following xmlelement types
Dim xe_CurrentCondi tions as XMLElement
Dim xe_CurrentCondi tionsChild As XMLElement
Dim xe_FiveDayForec ast as XMLElement
Dim xe_FiveDayForec astDay as XMLElement
Dim xe_FiveDayForec astDayDetails as XMLElement
3. Set your elements by doing the following
xe_CurrentCondi tions =
myXMLDoc.Select SingleNode("/weatherFeed/CurrentConditio ns") ' The
string in the function is an xpath expression
' this is extremely important to get familiar with when working with
' xml documents ALSO XML and XPath ARE CASE SENSTIVE AS WELL
4. You can cycle through your xe_CurrentCondi tions by using the following loop
For Each xe_CurrentCondi tionsChild in xe_CurrentCondi tions.childNode s
Dim strThisElementN ame as String
Dim strThisElementV alue as String
strThisElementN ame = xe_CurrentCondi tionsChild.Name ' Should yield country this 1st time thru your loop
strThisElementV alue = xe_CurrentCondi tionsChild.Inne rText ' Should Albania 1st time thru
Next
5. You can cycle through your FiveDayForecast by doing the same thing by using a nested For Each and getting your
xe_FiveDayForec ast =
myXMLDoc.Select SingleNode("wea therFeed/CurrentConditio ns/fiveDayForecast ")
For Each xe_FiveDayForec astDay in xe_xe_FiveDayFo recast.ChildNod es
' the elemnt name of xe_FiveDayForec astDay will be Day1 the
first time thru, Day2 the 2nd time thru...
For Each xe_FiveDayForec astDayDetails in
xe_FiveDayForec astDay.ChildNod es
Dim strThisElementN ame as String
Dim strThisElementV alue as String
' This will let you cycle through each <day>
<highCelius><lo wCelius> elements You can use them as you see fit.
strThisElementN ame = xe_CurrentCondi tionsChild.Name '
element name is
strThisElementV alue = xe_CurrentCondi tionsChild.Inne rText
Next
Next
I hope this helps.
Larry R
"Paul M" <mi******@hotma il.com> wrote in message
news:uP******** ******@tk2msftn gp13.phx.gbl...
> hi there,
>
> i have an xml file, but am not too sure how to read all these
elements using
> vb.net code.
>
> any help would be greatly appreciated:))
> <---------CODE--------------->
>
> <?xml version="1.0" encoding="utf-8"?>
> <weatherFeed>
> <CurrentConditi ons>
> <country>Albani a</country>
> <city>Tirana</city>
> <weatherImageUR L>cloudy.gif</weatherImageURL >
> <celcius>14°C </celcius>
> <farenheit>57°F </farenheit>
> <description>Pa rtly Cloudy</description>
> <relativeHumidi ty>61%</relativeHumidit y>
> <wind>WSW at 10 mph (16 km/h)</wind>
> <sunrise>7:05 AM</sunrise>
> <sunset>4:36 PM</sunset>
> <barometricPres sure>26.1Hg (F)</barometricPress ure>
> <lastUpdated> 15/01/2004 13:21:14</lastUpdated>
> <!--5 Day Weather Forecast-->
> <fiveDayForecas t>
> <Day1>
> <day>Thursday </day>
> <highCelcius>14 °C</highCelcius>
> <lowCelcius>1°C </lowCelcius>
> <highFarenheit> 58°F</highFarenheit>
> <lowFarenheit>3 3°F</lowFarenheit>
> <imageURL>cloud y.gif</imageURL>
> </Day1>
> <Day2>
> <day>Friday</day>
> <highCelcius>11 °C</highCelcius>
> <lowCelcius>1°C </lowCelcius>
> <highFarenheit> 51°F</highFarenheit>
> <lowFarenheit>3 4°F</lowFarenheit>
> <imageURL>cloud y.gif</imageURL>
> </Day2>
> <Day3>
> <day>Saturday </day>
> <highCelcius>11 °C</highCelcius>
> <lowCelcius>1°C </lowCelcius>
> <highFarenheit> 51°F</highFarenheit>
> <lowFarenheit>3 3°F</lowFarenheit>
> <imageURL>cloud y.gif</imageURL>
> </Day3>
> <Day4>
> <day>Sunday</day>
> <highCelcius>9° C</highCelcius>
> <lowCelcius>-1°C</lowCelcius>
> <highFarenheit> 49°F</highFarenheit>
> <lowFarenheit>3 1°F</lowFarenheit>
> <imageURL>rain. gif</imageURL>
> </Day4>
> <Day5>
> <day>Monday</day>
> <highCelcius>9° C</highCelcius>
> <lowCelcius>-4°C</lowCelcius>
> <highFarenheit> 49°F</highFarenheit>
> <lowFarenheit>2 4°F</lowFarenheit>
> <imageURL>snow. gif</imageURL>
> </Day5>
> </fiveDayForecast >
> </CurrentConditio ns>
> </weatherFeed>
> <---------CODE--------------->
>
> thanks in advance,
> PM
>
>
