Loop through xml elements

My xml is below.  I want to loop through my xml and create a new map element based on the values in that RetailTowns node


For Each XElement In myXML.Elements
            Dim retailPushpin As New Pushpin
            retailPushpin.Name = myXML.Elements("Town").Value
            retailPushpin.Location = New Location(myXML.Elements("Longitude").Value, myXML.Elements("Latitude").Value)
            retailPushpin.Content = myXML.Elements("Town").Value
            retailPushpin.Visibility = Visibility.Visible

            retailTowns.Children.Add(retailPushpin)
        Next

Open in new window

RetailTowns.xml
DotNetNoobyAsked:
Who is Participating?
 
kolakanuru1Connect With a Mentor Commented:
       For Each XElement As XmlElement In myXML.GetElementsByTagName("RetailTowns Query")
            Dim Town As String = XElement.SelectSingleNode("Town").InnerText
            Dim Longitude As String = XElement.SelectSingleNode("Longitude").InnerText
        Next
0
 
DotNetNoobyAuthor Commented:
I'm not able to access the As XML Element or myXML.GetElementsByTagName
    Sub LoadRetailTowns()
        Dim client As WebClient = New WebClient()
        AddHandler client.OpenReadCompleted, AddressOf OpenReadCallback
        Dim uri As Uri = New Uri("RetailTowns.XML", UriKind.Relative)
        client.OpenReadAsync(uri)
    End Sub
    Sub OpenReadCallback(ByVal sender As Object, ByVal e As OpenReadCompletedEventArgs)
        Dim myXML As XElement = XElement.Load(XmlReader.Create(e.Result))

        For Each XElement In myXML.Elements
            Dim retailPushpin As New Pushpin
            retailPushpin.Name = myXML.Elements("Town").Value
            retailPushpin.Location = New Location(myXML.Elements("Longitude").Value, myXML.Elements("Latitude").Value)
            retailPushpin.Content = myXML.Elements("Town").Value
        Next

    End Sub

Open in new window

0
 
kolakanuru1Connect With a Mentor Commented:
       Dim myXML As XmlDocument = New XmlDocument()
        myXML.Load(FileName)
        For Each XElement As XmlElement In myXML.GetElementsByTagName("RetailTowns Query")
            Dim Town As String = XElement.SelectSingleNode("Town").InnerText
            Dim Longitude As String = XElement.SelectSingleNode("Longitude").InnerText
        Next



Replace the filename with filepath of the xmldocument. This is working fine in my test.
0
 
DotNetNoobyAuthor Commented:
solved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.