Loading XML File into Windows Form

M

MQ

I need to read all the Address subnodes from the following
XML file using VB.net, any help would be appreciated.
Thanks
******************************************

- <root>
- <eConnect ACTION="2" DOCTYPE="Customer" INDEX1="02413">
- <Customer>
<CUSTNMBR>02413</CUSTNMBR>
<ADDRESS1>201 ENERGY PRKWY STE 310</ADDRESS1>
<ADDRESS2 />
<ADDRESS3 />
<ADRSCODE>COLLECT</ADRSCODE>
<CITY>LAFAYETTE</CITY>
<CNTCPRSN>STACEY & DUSTIN</CNTCPRSN>
<COUNTRY />
<CPRCSTNM>UPR</CPRCSTNM>
<CURNCYID />
<CUSTCLAS>TELLAFSVC</CUSTCLAS>
<CUSTDISC>0</CUSTDISC>
<CUSTNAME>ANADARKO</CUSTNAME>
<PHONE1>33757240120000</PHONE1>
<PHONE2>00000000000000</PHONE2>
<PHONE3 />
<FAX>33757240160000</FAX>
<PYMTRMID>Net 30 Days</PYMTRMID>
<SALSTERR>TELLAFSVC</SALSTERR>
<SHIPMTHD />
<SLPRSNID>5245-PRD</SLPRSNID>
<STATE>LA</STATE>
<TAXSCHID>FED</TAXSCHID>
<TXRGNNUM />
<UPSZONE />
<ZIP>70508</ZIP>
<CPRCSTNM>UPR</CPRCSTNM>
<STMTNAME>ANADARKO TEST RECORD</STMTNAME>
<SHRTNAME>ANADARKO</SHRTNAME>
<PRBTADCD>RENTAL</PRBTADCD>
<PRSTADCD>SHIPTO</PRSTADCD>
<STADDRCD>PRIMARY</STADDRCD>
<CHEKBKID>CHASE-OPERATING</CHEKBKID>
<CRLMTTYP>2</CRLMTTYP>
<CRLMTAMT>679400.00000</CRLMTAMT>
<CRLMTPER>0</CRLMTPER>
<CRLMTPAM>0.00000</CRLMTPAM>
<RATETPID />
<CUSTDISC>0</CUSTDISC>
<PRCLEVEL />
<MINPYTYP>0</MINPYTYP>
<MINPYDLR>0.00000</MINPYDLR>
<MINPYPCT>0</MINPYPCT>
<FNCHATYP>0</FNCHATYP>
<FNCHPCNT>0</FNCHPCNT>
<FINCHDLR>0.00000</FINCHDLR>
<MXWOFTYP>2</MXWOFTYP>
<MXWROFAM>25.00000</MXWROFAM>
<COMMENT1>ROCH JUDICE</COMMENT1>
<COMMENT2>Dustin a/p</COMMENT2>
<USERDEF1>O</USERDEF1>
<USERDEF2>M/D/D</USERDEF2>
<TAXEXMT1>LA EX CERT VARIOUS OCSG</TAXEXMT1>
<TAXEXMT2 />
<TXRGNNUM />
<BALNCTYP>0</BALNCTYP>
<STMTCYCL>5</STMTCYCL>
<BANKNAME />
<BNKBRNCH />
<SALSTERR>TELLAFSVC</SALSTERR>
<FRSTINDT>Jan 1 1900 12:00AM</FRSTINDT>
<INACTIVE>0</INACTIVE>
<HOLD>0</HOLD>
<CRCARDID />
<CRCRDNUM />
<CCRDXPDT>Jan 1 1900 12:00AM</CCRDXPDT>
<KPDSTHST>1</KPDSTHST>
<KPCALHST>1</KPCALHST>
<KPERHIST>1</KPERHIST>
<KPTRXHST>1</KPTRXHST>
<CREATDDT>Sep 15 1995 12:00AM</CREATDDT>
<MODIFDT>Jun 10 2003 12:00AM</MODIFDT>
<Revalue_Customer>0</Revalue_Customer>
<Post_Results_To>0</Post_Results_To>
<FINCHID />
<GOVCRPID />
<GOVINDID />
<DISGRPER>0</DISGRPER>
<DUEGRPER>0</DUEGRPER>
<DOCFMTID />
<Send_Email_Statements>0</Send_Email_Statements>
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>SS291</ADRSCODE>
<SLPRSNID>TELNORHOUSE</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID />
<CNTCPRSN>Aten John Bertrand</CNTCPRSN>
<ADDRESS1>210 ENERGY PARKWAY, SUITE 310</ADDRESS1>
<ADDRESS2 />
<ADDRESS3 />
<COUNTRY />
<CITY>LAFAYETTE</CITY>
<STATE>LA</STATE>
<ZIP>70508-3839</ZIP>
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>SS349</ADRSCODE>
<SLPRSNID>5245-RNT</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>FED</TAXSCHID>
<CNTCPRSN />
<ADDRESS1 />
<ADDRESS2 />
<ADDRESS3 />
<COUNTRY />
<CITY />
<STATE />
<ZIP />
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>ST143</ADRSCODE>
<SLPRSNID>5245-LEA</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>FED</TAXSCHID>
<CNTCPRSN>John Bertand</CNTCPRSN>
<ADDRESS1>201 ENERGY PARKWAY, SUITE 310</ADDRESS1>
<ADDRESS2>Attn: John Bertrand</ADDRESS2>
<ADDRESS3 />
<COUNTRY />
<CITY>LAFAYETTE</CITY>
<STATE>LA</STATE>
<ZIP>70508-3839</ZIP>
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>ST198</ADRSCODE>
<SLPRSNID>5245-LEA</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>FED</TAXSCHID>
<CNTCPRSN>John Bertand</CNTCPRSN>
<ADDRESS1>201 ENERGY PARKWAY, SUITE 310</ADDRESS1>
<ADDRESS2>Attn: John Bertrand</ADDRESS2>
<ADDRESS3 />
<COUNTRY />
<CITY>LAFAYETTE</CITY>
<STATE>LA</STATE>
<ZIP>70508-3839</ZIP>
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>STRATOSWILLOW</ADRSCODE>
<SLPRSNID>5245-LEA</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>LA30</TAXSCHID>
<CNTCPRSN>John Bertand</CNTCPRSN>
<ADDRESS1>201 ENERGY PARKWAY, SUITE 310</ADDRESS1>
<ADDRESS2>Attn: John Bertrand</ADDRESS2>
<ADDRESS3 />
<COUNTRY />
<CITY>LAFAYETTE</CITY>
<STATE>LA</STATE>
<ZIP>70508-3839</ZIP>
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>SUPR CHAMPION</ADRSCODE>
<SLPRSNID>TELNORHOUSE</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>FED</TAXSCHID>
<CNTCPRSN />
<ADDRESS1>201 ENERGY PARKWAY</ADDRESS1>
<ADDRESS2>SUITE 310</ADDRESS2>
<ADDRESS3 />
<COUNTRY />
<CITY>LAFAYETTE</CITY>
<STATE>LA</STATE>
<ZIP>70508</ZIP>
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>VE78</ADRSCODE>
<SLPRSNID>5245-LEA</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>FED</TAXSCHID>
<CNTCPRSN />
<ADDRESS1 />
<ADDRESS2 />
<ADDRESS3 />
<COUNTRY />
<CITY />
<STATE />
<ZIP />
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
- <Address>
<CUSTNMBR>02413</CUSTNMBR>
<ADRSCODE>WD152</ADRSCODE>
<SLPRSNID>TELNORHOUSE</SLPRSNID>
<UPSZONE />
<SHIPMTHD />
<TAXSCHID>FED</TAXSCHID>
<CNTCPRSN />
<ADDRESS1 />
<ADDRESS2 />
<ADDRESS3 />
<COUNTRY />
<CITY />
<STATE />
<ZIP />
<PHONE1 />
<PHONE2 />
<PHONE3 />
<FAX />
<GPSFOINTEGRATIONID />
<INTEGRATIONSOURCE>0</INTEGRATIONSOURCE>
<INTEGRATIONID />
<Internet_Address />
</Address>
</Customer>
</eConnect>
</root>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extracting info from an address block 10
VCard Business Address Line 1
ADODB.Connection error '800a0e7c' 2
Char(10) and blank lines 6
ADODB.Connection error '800a0e7c' 1
NullReference Exception inside remoting 1
Formatting Mailing Addresses 1
How do I determine if a element exists in an xml file? 7

Top