1030071002
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</p2 31: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:proNu m>
<p231:proDate>10/21/2011</ p231:proDa te>
<p231:statusCode>DEL</p231 :statusCod e>
<p231:status>Delivered</p2 31:status>
<p231:appointment />
<p231:pieces>1</p231:piece s>
<p231:weight>860</p231:wei ght>
<p231:po>1184987</p231:po>
<p231:bol>0074887000724682 3</p231:bo l>
<p231:trailer />
<p231:signature />
<p231:origTerminal>IND</p2 31:origTer minal>
<p231:origAddress>3915 WEST MORRIS STREET</p231:origAddress>
<p231:origState>IN</p231:o rigState>
<p231:origName>INDIANAPOLI S, IN</p231:origName>
<p231:origCity>INDIANAPOLI S</p231:or igCity>
<p231:origZip>46241</p231: origZip>
<p231:origPhone>(800) 450-6335</p231:origPhone>
<p231:origFax>(317) 481-8200</p231:origFax>
<p231:destTerminal>PVD</p2 31:destTer minal>
<p231:destAddress>80 INDUSTRIAL DRIVE</p231:destAddress>
<p231:destState>RI</p231:d estState>
<p231:destName>PROVIDENCE, RI</p231:destName>
<p231:destCity>CUMBERLAND< /p231:dest City>
<p231:destZip>02864</p231: destZip>
<p231:destPhone>(800) 847-4611</p231:destPhone>
<p231:destFax>(401) 334-9905</p231:destFax>
<p231:delivered>Y</p231:de livered>
<p231:url />
<p231:type>P</p231:type>
<p231:scac />
<p231:errorMessage />
<p231:guaranteed>N</p231:g uaranteed>
<p231:call>N</p231:call>
</p231:getTraceDataReturn>
</p231:getTraceDataRespons e>
</soapenv:Body>
</soapenv:Envelope>
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
- <p231:getTraceDataReturn>
<p231:proNum>05510105462</
<p231:proDate>10/21/2011</
<p231:statusCode>DEL</p231
<p231:status>Delivered</p2
<p231:appointment />
<p231:pieces>1</p231:piece
<p231:weight>860</p231:wei
<p231:po>1184987</p231:po>
<p231:bol>0074887000724682
<p231:trailer />
<p231:signature />
<p231:origTerminal>IND</p2
<p231:origAddress>3915 WEST MORRIS STREET</p231:origAddress>
<p231:origState>IN</p231:o
<p231:origName>INDIANAPOLI
<p231:origCity>INDIANAPOLI
<p231:origZip>46241</p231:
<p231:origPhone>(800) 450-6335</p231:origPhone>
<p231:origFax>(317) 481-8200</p231:origFax>
<p231:destTerminal>PVD</p2
<p231:destAddress>80 INDUSTRIAL DRIVE</p231:destAddress>
<p231:destState>RI</p231:d
<p231:destName>PROVIDENCE,
<p231:destCity>CUMBERLAND<
<p231:destZip>02864</p231:
<p231:destPhone>(800) 847-4611</p231:destPhone>
<p231:destFax>(401) 334-9905</p231:destFax>
<p231:delivered>Y</p231:de
<p231:url />
<p231:type>P</p231:type>
<p231:scac />
<p231:errorMessage />
<p231:guaranteed>N</p231:g
<p231:call>N</p231:call>
</p231:getTraceDataReturn>
</p231:getTraceDataRespons
</soapenv:Body>
</soapenv:Envelope>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
.
ASKER