Namespace iterration 1

[Dashley]

Hi,

Im using a namespace manager to pull data from an xml source.
Dim history As XmlElement = DirectCast(XmlResponse.SelectSingleNode("df:Response/df:History/df:HistoryItem/df:Activity", mgr), XmlElement)

In the xml data there are several history items I'l like to itterate through and pull out the <Activity> innertext.
Any Ideas?

Thanks


<History>
<HistoryItem>
<ActivityDateTime>2010-01-08 13:13:00</ActivityDateTime>
<Activity>Arrived at Breakbulk Terminal</Activity>
<City>Boise</City>
<State>ID</State>
</HistoryItem>
<HistoryItem>
<ActivityDateTime>2010-01-07 02:39:00</ActivityDateTime>
<Activity>Departed from Terminal</Activity>
<City>Pasco</City>
<State>WA</State>
</HistoryItem>
<HistoryItem>
<ActivityDateTime>2010-01-06 20:28:00</ActivityDateTime>
<Activity>Load Trailer: 286286</Activity>
<City>Pasco</City>
<State>WA</State>
</HistoryItem>
<HistoryItem>
<ActivityDateTime>2010-01-06 17:43:00</ActivityDateTime>
<Activity>Unload Trailer: 286118</Activity>
<City>Pasco</City>
<State>WA</State>
</HistoryItem>
<HistoryItem>
<ActivityDateTime>2010-01-06 17:39:00</ActivityDateTime>
<Activity>Unload Trailer: 286118</Activity>
<City>Pasco</City>
<State>WA</State>
</HistoryItem>
<HistoryItem>
<ActivityDateTime>2010-01-06 17:39:00</ActivityDateTime>
<Activity>Arrived at Origin Terminal</Activity>
<City>Pasco</City>
<State>WA</State>
</HistoryItem>
<HistoryItem>
<ActivityDateTime>2010-01-06 16:00:00</ActivityDateTime>
<Activity>Pickup from Customer</Activity>
<City>OUTLOOK</City>
<State>WA</State>
</HistoryItem>
</History>

 

[tsuji]

Use SelectNodes method instead.

http://msdn.microsoft.com/en-us/library/system.xml.xmlnode.selectnodes.aspx

 

[Dashley]

Thanks Tsuji.

Great Sample too.

I got it now. Appreciate it.