reading xml file with asp.net
If I had the xml file below, could I read this and get
the product id, code, description, weight, and price in an array where array(0, 3) would be row 1 weight data
and array(1, 3) would be row 2 weight data?
Trying to figure out xml and wondering if this is even possible.
What's the easiest way to get data from an xml file to load only the data you need to say a file or database?
Thanks for the help in advance.
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SiteExport SYSTEM "http://........./TestSiteExport.dtd">
<SiteExport>
<Settings>
<Published timestamp="1084036444"/>
<Locale code="C" name="English" encoding="iso-8859-1"/>
<SiteName>Test Site</SiteName>
<Currency>USD</Currency>
<ShipMethods>
<ShipMethod>UPS Ground Residential</ShipMethod>
<ShipMethod>3 Day Select Residential</ShipMethod>
</ShipMethods>
<PayMethods>
<PayMethod>Cashier's Check or Money Order</PayMethod>
<PayMethod>Discover</PayMethod>
<PayMethod>MasterCard</PayMethod>
<PayMethod>Visa</PayMethod>
</PayMethods>
</Settings>
<Products>
<Product Id="123">
<Code>123 - Bags</Code>
<Description>123 Description</Description>
<Url>http://www.site.com/test1.htm</Url>
<Weight>1</Weight>
<Orderable>YES</Orderable>
<Taxable>YES</Taxable>
<Pricing>
<BasePrice>19.95</BasePrice>
<LocalizedBasePrice>19.95</LocalizedBasePrice>
<AdditionalCharge>0</AdditionalCharge>
</Pricing>
<Caption>123 Bags - Package of 10</Caption>
</Product>
<Product Id="234">
<Code>Zebra 234</Code>
<Description>Zebra 234</Description>
<Url>http://www.site.com/test2.html</Url>
<Weight>22</Weight>
<Orderable>YES</Orderable>
<Taxable>YES</Taxable>
<Pricing>
<BasePrice>25.75</BasePrice>
<LocalizedBasePrice>25.75</LocalizedBasePrice>
<AdditionalCharge>0</AdditionalCharge>
</Pricing>
<Caption>Zebra 234</Caption>
</Product>
</Products>
</SiteExport>
