hello,
I was reading the
article related to integration of an XML with VB.NET but I was faced with a problem.
The example from the article works fine on my PC but I couldn't handled with my XML file
<order>
<HEADER>
<bu>ITA</bu>
<order_no>4310003289</order_no>
<cust_grp_name>AMAZON</cust_grp_name>
<cust_grp_id>433622</cust_grp_id>
</HEADER>
<lines>
<line>
<order_line_no>1</order_line_no>
<product_id>3000123</product_id>
<quantity>12</quantity>
<price>15.6</price>
<order_date>24052011</order_date>
<order_date_receipt>24052011</order_date_receipt>
<delivery_date>31052011</delivery_date>
<cust_id>A662</cust_id>
<delivery_address>Belgium,Bruxelles,St.Patrick str,no.12</delivery_address>
<delivery_address_id>2</delivery_address_id>
</line>
<line>
<order_line_no>2</order_line_no>
<product_id>3000124</product_id>
<quantity>2</quantity>
<price>15.6</price>
<order_date>24052011</order_date>
<order_date_receipt>24052011</order_date_receipt>
<delivery_date>31052011</delivery_date>
<cust_id>A662</cust_id>
<delivery_address>Belgium,Bruxelles,St.Patrick str,no.12</delivery_address>
<delivery_address_id>2</delivery_address_id>
</line>
<line>
<order_line_no>3</order_line_no>
<product_id>3000125</product_id>
<quantity>8</quantity>
<price>15.6</price>
<order_date>24052011</order_date>
<order_date_receipt>24052011</order_date_receipt>
<delivery_date>31052011</delivery_date>
<cust_id>A662</cust_id>
<delivery_address>Belgium,Bruxelles,St.Patrick str,no.12</delivery_address>
<delivery_address_id>2</delivery_address_id>
</line>
<line>
<order_line_no>4</order_line_no>
<product_id>3000300</product_id>
<quantity>120</quantity>
<price>0.25</price>
<order_date>24052011</order_date>
<order_date_receipt>24052011</order_date_receipt>
<delivery_date>31052011</delivery_date>
<cust_id>A662</cust_id>
<delivery_address>Belgium,Bruxelles,St.Patrick str,no.12</delivery_address>
<delivery_address_id>2</delivery_address_id>
</line>
<line>
<order_line_no>5</order_line_no>
<product_id>3000101</product_id>
<quantity>28</quantity>
<price>2.5</price>
<order_date>24052011</order_date>
<order_date_receipt>24052011</order_date_receipt>
<delivery_date>31052011</delivery_date>
<cust_id>A662</cust_id>
<delivery_address>Belgium,Bruxelles,St.Patrick str,no.12</delivery_address>
<delivery_address_id>2</delivery_address_id>
</line>
<line>
<order_line_no>6</order_line_no>
<product_id>3000102</product_id>
<quantity>45</quantity>
<price>3.2</price>
<order_date>24052011</order_date>
<order_date_receipt>24052011</order_date_receipt>
<delivery_date>31052011</delivery_date>
<cust_id>A662</cust_id>
<delivery_address>Belgium,Bruxelles,St.Patrick str,no.12</delivery_address>
<delivery_address_id>2</delivery_address_id>
</line>
</lines>
</order>
The values I want to be added into some variables from where to go into an SQL table.
My first problem is that I don't succeed getting the value of <order_no> into a variable.
Can someone help me explaining how to get that value from my XML file, please?
Thanks a lot,
Ionut Preda.