Jump to content


Photo

XML Query Assistance

xml query

  • Please log in to reply
No replies to this topic

#1 whiteboikyle

whiteboikyle

    Advanced Member

  • Members
  • PipPipPip
  • 290 posts

Posted 11 March 2014 - 12:02 AM

 
 

Im use to PHP and doing a query seems similar but i need help with syntax.

 

I have an XML file that looks like this

 


<?xml version="1.0" standalone="yes"?>
  <switchIP>
    <SwitchName>ES1UA1</SwitchName>
    <IP>205.71.10.4</IP>
    <Location>02-157-1-q</Location>
  </switchIP>
  <switchIP>
    <SwitchName>ES2UA1</SwitchName>
    <IP>205.71.10.5</IP>
    <Location>02-157-1-q</Location>
  </switchIP>
</DataSet1>
and i am trying to do a query where it will search for "ES2UA1" and i get the data "IP" and "Location"
 
I know i am some where in the ball park with
Dim doc = XDocument.Load(My.Application.Info.DirectoryPath & ".\xmlData.xml")

Dim marker2 = From x In doc...<switchIP> _
                  Where x.SwitchName = "ES1UA1" _
                  Select x
for each x as y
msgbox(y.IP)


Edited by whiteboikyle, 11 March 2014 - 12:02 AM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com