Link to home
Start Free TrialLog in
Avatar of 1030071002
1030071002Flag for United States of America

asked on

How do i parse xml in vb.net i would like to get colounm and the value from the xml

How do i parse xml in vb.net i would like to get colounm and the value from the xml so for example I want the  <p231:status>Delivered</p231:status> The colounm name which is status which is represented with one veriable and the value which is Delivered that would assign to a different veriable.
here is the xml :

- <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <soapenv:Header />
- <soapenv:Body>
- <p231:getTraceDataResponse xmlns:p231="http://trace.odfl.com">
- <p231:getTraceDataReturn>
  <p231:proNum>05510105462</p231:proNum>
  <p231:proDate>10/21/2011</p231:proDate>
  <p231:statusCode>DEL</p231:statusCode>
  <p231:status>Delivered</p231:status>
  <p231:appointment />
  <p231:pieces>1</p231:pieces>
  <p231:weight>860</p231:weight>
  <p231:po>1184987</p231:po>
  <p231:bol>00748870007246823</p231:bol>
  <p231:trailer />
  <p231:signature />
  <p231:origTerminal>IND</p231:origTerminal>
  <p231:origAddress>3915 WEST MORRIS STREET</p231:origAddress>
  <p231:origState>IN</p231:origState>
  <p231:origName>INDIANAPOLIS, IN</p231:origName>
  <p231:origCity>INDIANAPOLIS</p231:origCity>
  <p231:origZip>46241</p231:origZip>
  <p231:origPhone>(800) 450-6335</p231:origPhone>
  <p231:origFax>(317) 481-8200</p231:origFax>
  <p231:destTerminal>PVD</p231:destTerminal>
  <p231:destAddress>80 INDUSTRIAL DRIVE</p231:destAddress>
  <p231:destState>RI</p231:destState>
  <p231:destName>PROVIDENCE, RI</p231:destName>
  <p231:destCity>CUMBERLAND</p231:destCity>
  <p231:destZip>02864</p231:destZip>
  <p231:destPhone>(800) 847-4611</p231:destPhone>
  <p231:destFax>(401) 334-9905</p231:destFax>
  <p231:delivered>Y</p231:delivered>
  <p231:url />
  <p231:type>P</p231:type>
  <p231:scac />
  <p231:errorMessage />
  <p231:guaranteed>N</p231:guaranteed>
  <p231:call>N</p231:call>
  </p231:getTraceDataReturn>
  </p231:getTraceDataResponse>
  </soapenv:Body>
  </soapenv:Envelope>
ASKER CERTIFIED SOLUTION
Avatar of Jini Jose
Jini Jose
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 1030071002

ASKER

can I get some scripts to start with I cant figure out how this work I have a wsdl file
.