XML Query Assistance

[whiteboikyle]

 

 

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"?>

<DataSet1 xmlns="http://tempuri.org/DataSet1.xsd">

  <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 March 11, 2014 by whiteboikyle