Databases
StackOverflow2013
Postsdbo
PORead chunks of XML data in between <product></product> tags and insert fields into SQL Database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORead chunks of XML data in between <product></product> tags and insert fields into SQL Database
    primarykey
    data
    text
    <p>I am using following VB.Net Code to download large XML file ( 64 MB ) using VB.NET and save it locally, which works great, the XML feed looks like below.</p> <p>My xml feed url is <strong>http://www.topbuy.com.au/tbcart/tbadmin/datafeed/shoppingcom.xml</strong></p> <p>I am trying to achieve and need suggestions is instead of Downloading the file and store it locally, is there a way in VB.Net to read chunks of XML data in between tags and insert fields into SQL Database. Any examples, what should i change in the below code <strong>( VB.Net)</strong> </p> <pre><code>Dim remoteUri As String = "http://www.topbuy.com.au/tbcart/tbadmin/datafeed/" Dim fileName As String = "shoppingcom.xml" Dim myStringWebResource As String = Nothing ' Create a new WebClient instance. Dim myWebClient As New WebClient() ' Concatenate the domain with the Web resource filename. Because DownloadFile 'requires a fully qualified resource name, concatenate the domain with the Web resource file name. myStringWebResource = remoteUri + fileName Console.WriteLine("Downloading File ""{0}"" from ""{1}"" ......." + ControlChars.Cr + ControlChars.Cr, fileName, myStringWebResource) ' The DownloadFile() method downloads the Web resource and saves it into the current file-system folder. myWebClient.DownloadFile(myStringWebResource, fileName) Console.WriteLine("Successfully Downloaded file ""{0}"" from ""{1}""", fileName, myStringWebResource) Console.WriteLine((ControlChars.Cr + "Downloaded file saved in the following file system folder:" + ControlChars.Cr + ControlChars.Tab + Application.StartupPath)) </code></pre> <p><strong>XML</strong> </p> <pre><code>&lt;Products&gt; &lt;Product&gt;&lt;MPN&gt;&lt;![CDATA[INK-PE-009]]&gt;&lt;/MPN&gt;&lt;Manufacturer&gt;&lt;![CDATA[Epson]]&gt;&lt;/Manufacturer&gt;&lt;ProductName&gt;&lt;![CDATA[Epson T009 Colour Compatible Inkjet Cartridge]]&gt;&lt;/ProductName&gt;&lt;ProductURL&gt;&lt;![CDATA[http://www.topbuy.com.au/tbcart/pc/Epson-T009-Colour-Compatible-Inkjet-Cartridge-p3343.htm?utm_source=TopBuy_ShoppingCom&amp;utm_content=&amp;utm_medium=cpc&amp;dismode=1&amp;utm_campaign=TBDF-XX10421]]&gt;&lt;/ProductURL&gt;&lt;ProductType&gt;&lt;![CDATA[Compatible Ink Cartridges]]&gt;&lt;/ProductType&gt;&lt;ImageURL&gt;&lt;![CDATA[http://www2.topbuy.com.au/tbcart/pc/catalog/General/TBDF-XX10421_1.jpg]]&gt;&lt;/ImageURL&gt;&lt;Price&gt;4.09&lt;/Price&gt;&lt;OriginalPrice&gt;9&lt;/OriginalPrice&gt;&lt;Category&gt;&lt;![CDATA[Consumables-&gt;Compatible Ink Cartridges]]&gt;&lt;/Category&gt;&lt;ProductDescription&gt;&lt;![CDATA[$4.05 Cash Price see store for detailsRelated Brand EpsonOriginal Cartridge Equivalent T009Related Printers STYLUS 1270, STYLUS 1280, STYLUS 1290, STYLUS 3300C, STYLUS PHOTO 1270, STYLUS PHOTO 1290, STYLUS PHOTO 1290 silverThis cartridge works in the following printers Epson Stylus Photo 1270/1280Please check the name (code) of the cartridge in your printer before ordering to ensure that it matches the name of the cartridges you are ordering from us. In some instances a printer can take more than one cartridge type and ...]]&gt;&lt;/ProductDescription&gt;&lt;Stock&gt;Y&lt;/Stock&gt;&lt;ShippingCost&gt;10&lt;/ShippingCost&gt;&lt;StockDescription&gt;No.1 OZ SUPERSTORE AUS WARRANTY FAST SHIPPING&lt;/StockDescription&gt;&lt;Condition&gt;Brand New&lt;/Condition&gt;&lt;/Product&gt; &lt;Product&gt;&lt;MPN&gt;&lt;![CDATA[INK-PE-013]]&gt;&lt;/MPN&gt;&lt;Manufacturer&gt;&lt;![CDATA[Epson]]&gt;&lt;/Manufacturer&gt;&lt;ProductName&gt;&lt;![CDATA[Epson T013 Black Compatible Inkjet Cartridge]]&gt;&lt;/ProductName&gt;&lt;ProductURL&gt;&lt;![CDATA[http://www.topbuy.com.au/tbcart/pc/Epson-T013-Black-Compatible-Inkjet-Cartridge-p3345.htm?utm_source=TopBuy_ShoppingCom&amp;utm_content=&amp;utm_medium=cpc&amp;dismode=1&amp;utm_campaign=TBDF-XX10423]]&gt;&lt;/ProductURL&gt;&lt;ProductType&gt;&lt;![CDATA[Compatible Ink Cartridges]]&gt;&lt;/ProductType&gt;&lt;ImageURL&gt;&lt;![CDATA[http://www2.topbuy.com.au/tbcart/pc/catalog/General/TBDF-XX10423_1.jpg]]&gt;&lt;/ImageURL&gt;&lt;Price&gt;2.09&lt;/Price&gt;&lt;OriginalPrice&gt;5&lt;/OriginalPrice&gt;&lt;Category&gt;&lt;![CDATA[Consumables-&gt;Compatible Ink Cartridges]]&gt;&lt;/Category&gt;&lt;ProductDescription&gt;&lt;![CDATA[$2.07 Cash Price see store for detailsRelated Brand EpsonOriginal Cartridge Equivalent T013Related Printers STYLUS COLOR 480, STYLUS COLOR 580, STYLUS COLOR C20, STYLUS COLOR C40, STYLUS COLOUR 480, STYLUS COLOUR 580, STYLUS COLOUR C20UX, STYLUS COLOUR C40SX, STYLUS COLOUR C40UXThis cartridge works in the following printers Epson Stylus Colour 480/580Please check the name (code) of the cartridge in your printer before ordering to ensure that it matches the name of the cartridges you are ordering from us. In some instances a ...]]&gt;&lt;/ProductDescription&gt;&lt;Stock&gt;Y&lt;/Stock&gt;&lt;ShippingCost&gt;10&lt;/ShippingCost&gt;&lt;StockDescription&gt;No.1 OZ SUPERSTORE AUS WARRANTY FAST SHIPPING&lt;/StockDescription&gt;&lt;Condition&gt;Brand New&lt;/Condition&gt;&lt;/Product&gt; &lt;/Products&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser580950
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO64MB is not that large. Your code will be much easier (to write, read and understand) if you can use `System.Xml.Linq` instead of using an `XmlReader`. Xml.Linq code is much much more maintainable. So... If memory is not an issue, consider using it.
      singulars
      1. PORead chunks of XML data in between <product></product> tags and insert fields into SQL Database
      1. USLaoujin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload