Import data through xml with linq

EDN Admin · Feb 9, 2011

Hello,
I am struggling to import xml into a dataset. The error is: "enumeration yielded no results". The error occurs where the query is filled.
Can someone help me.
<div style="color:black; background-color:white
<pre><span style="color:blue Option Strict <span style="color:blue Off
<span style="color:blue Option Infer <span style="color:blue On
<span style="color:blue Imports System.Xml
<span style="color:blue Imports System.Linq
<span style="color:blue Imports System.Collections
<span style="color:blue Imports System.Data
<span style="color:blue Imports System
<span style="color:blue Imports <xmlns=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:spreadsheet">
<span style="color:blue Imports <xmlns

=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice

ffice">
<span style="color:blue Imports <xmlns:x=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:excel">
<span style="color:blue Imports <xmlns:ss=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:spreadsheet">


<span style="color:blue Public <span style="color:blue Shared <span style="color:blue Function ImportFromExcel(<span style="color:blue ByVal ds <span style="color:blue As DataSet, <span style="color:blue ByVal FileSavePath <span style="color:blue As <span style="color:blue String) <span style="color:blue As DataSet

<span style="color:blue Dim dt <span style="color:blue As DataTable = ds.Tables(0)
<span style="color:blue Dim r <span style="color:blue As DataRow
 _
.Value = <span style="color:#a31515 "OKE" _
<span style="color:blue Select xmlFACT _
<span style="color:blue Skip (1)

<span style="color:blue For .Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
.Item(.Value
<span style="color:blue End <span style="color:blue With

dt.Rows.Add(r)
<span style="color:blue Next

<?xml version=
<?mso-application progid=
<Workbook xmlns=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:spreadsheet"
xmlns

=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice

ffice"
xmlns:x=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:excel"
xmlns:ss=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:spreadsheet"
xmlns:html=
<DocumentProperties xmlns=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice

ffice">
<Author>MSADMIN</Author>
<LastAuthor>MSADMIN</LastAuthor>
<Created>2007-10-23T23:40:11Z</Created>
<Company>Microsoft</Company>
<Version>12.00</Version>
</DocumentProperties>
<ExcelWorkbook xmlns=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:excel">
<WindowHeight>6600</WindowHeight>
<WindowWidth>12255</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>60</WindowTopY>
<ProtectStructure>
<ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID=
<Alignment ss:Vertical=
<Borders/>

<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID=
<Borders>
<Border ss

osition=
</Borders>
<Font ss:FontName=
</Style>
<Style ss:ID=
<Borders/>
<Font ss:FontName=
<Interior/>
</Style>
</Styles>
<Worksheet ss:Name=
<Table ss:ExpandedColumnCount=<span style="color:#a31515 "15" ss:ExpandedRowCount=<span style="color:#a31515 "227" x:FullColumns=<span style="color:#a31515 "1"
x:FullRows=<span style="color:#a31515 "1" ss

efaultRowHeight=
<Row>
<Cell ss:StyleID=<Data ss:Type=ARTIKELNUMMER</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=OMSCHRIJVING</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=ZOEKNAAM</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=FAKTUURDATUM</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=LTSPRIJS</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=NETTOIKP</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=FACTOR</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=DATUMPRIJSWIJZ</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=FYSIEK</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=HUIDVVP</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=NIEUWVVP</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=VVPWAARDE</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=VVPWAARDENIEUW</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=UPDATE</Data></Cell>
<Cell ss:StyleID=<Data ss:Type=OKE</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type=4000000009 </Data></Cell>
<Cell><Data ss:Type=Taper roller bearing 30216 </Data></Cell>
<Cell><Data ss:Type=BEARING </Data></Cell>
<Cell><Data ss:Type=2011-01-11T00:00:00</Data></Cell>
<Cell><Data ss:Type=23.87</Data></Cell>
<Cell><Data ss:Type=23.87</Data></Cell>
<Cell><Data ss:Type=0.25</Data></Cell>
<Cell><Data ss:Type=2011-02-04T00:00:00</Data></Cell>
<Cell><Data ss:Type=7</Data></Cell>
<Cell><Data ss:Type=22.99</Data></Cell>
<Cell><Data ss:Type=28.64</Data></Cell>
<Cell><Data ss:Type=160.93</Data></Cell>
<Cell><Data ss:Type=200.48000000000002</Data></Cell>
<Cell><Data ss:Type=Ja</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type=4000000011 </Data></Cell>
<Cell><Data ss:Type=Taper roller bearing 30218 </Data></Cell>
<Cell><Data ss:Type=BEARING </Data></Cell>
<Cell><Data ss:Type=2010-11-03T00:00:00</Data></Cell>
<Cell><Data ss:Type=61</Data></Cell>
<Cell><Data ss:Type=61</Data></Cell>
<Cell><Data ss:Type=1.32</Data></Cell>
<Cell><Data ss:Type=2011-02-04T00:00:00</Data></Cell>
<Cell><Data ss:Type=1</Data></Cell>
<Cell><Data ss:Type=31.56</Data></Cell>
<Cell><Data ss:Type=73.2</Data></Cell>
<Cell><Data ss:Type=31.56</Data></Cell>
<Cell><Data ss:Type=73.2</Data></Cell>
<Cell><Data ss:Type=Ja</Data></Cell>
<Cell><Data ss:Type=OKE</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type=4000000012 </Data></Cell>
<Cell><Data ss:Type=Taper roller bearing 30244 </Data></Cell>
<Cell><Data ss:Type=BEARING </Data></Cell>
<Cell><Data ss:Type=2010-11-25T00:00:00</Data></Cell>
<Cell><Data ss:Type=2075</Data></Cell>
<Cell><Data ss:Type=2075</Data></Cell>
<Cell><Data ss:Type=1.6</Data></Cell>
<Cell><Data ss:Type=2011-02-04T00:00:00</Data></Cell>
<Cell><Data ss:Type=3</Data></Cell>
<Cell><Data ss:Type=957.5</Data></Cell>
<Cell><Data ss:Type=2490</Data></Cell>
<Cell><Data ss:Type=2872.5</Data></Cell>
<Cell><Data ss:Type=7470</Data></Cell>
<Cell><Data ss:Type=Ja</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type=4000000013 </Data></Cell>
<Cell><Data ss:Type=Taper roller bearing 30315 </Data></Cell>
<Cell><Data ss:Type=BEARING </Data></Cell>
<Cell><Data ss:Type=2011-01-26T00:00:00</Data></Cell>
<Cell><Data ss:Type=35.4</Data></Cell>
<Cell><Data ss:Type=35.4</Data></Cell>
<Cell><Data ss:Type=0.24</Data></Cell>
<Cell><Data ss:Type=2011-02-04T00:00:00</Data></Cell>
<Cell><Data ss:Type=4</Data></Cell>
<Cell><Data ss:Type=56.23</Data></Cell>
<Cell><Data ss:Type=44.25</Data></Cell>
<Cell><Data ss:Type=224.92</Data></Cell>
<Cell><Data ss:Type=177</Data></Cell>
<Cell><Data ss:Type=Ja</Data></Cell>
<Cell><Data ss:Type=OKE</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns=<span style="color:#a31515 "urn:schemas-microsoft-com

ffice:excel">
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>4</ActiveRow>
<ActiveCol>14</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>
<ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<x:WorksheetOptions>
<x

ageSetup>
<x:Header x:Margin=
<x:Footer x:Margin=
<x

ageMargins x:Bottom=
</x

ageSetup>
<x

rint>
<x:ValidPrinterInfo/>
<x:HorizontalResolution>300</x:HorizontalResolution>
<x:VerticalResolution>300</x:VerticalResolution>
</x

rint>
<x:Selected/>
<x

anes>
<x

ane>
<x:Number>3</x:Number>
<x:ActiveCol>2</x:ActiveCol>
</x

ane>
</x

anes>
<x

rotectObjects><span style="color:blue False</x

rotectObjects>
<x

rotectScenarios><span style="color:blue False</x

rotectScenarios>
</x:WorksheetOptions>
</Workbook>
[/code]

View the full article

Import data through xml with linq

EDN Admin

Well-known member