September 6, 2008 03:08pm pdt

1. naspinski 52,450
2. Fernando... 44,300
3. CarlVerret 17,064
4. sjturner2 14,250
5. Ceiled 12,500
6. CMYScott 5,750
7. TheLearn... 5,172
8. Praesidium 4,664
9. GreenGho... 4,150
10. VBRocks 4,000
11. emoreau 3,050
12. gardavis 3,000
12. Dhaest 3,000
14. ZachSmith 2,600
15. boag2000 2,500
15. mark_wills 2,500
17. IndianOcean 2,000
17. vb_jonas 2,000
17. SwissKnife 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. primeMov... 2,000
17. JimFive 2,000
17. AaronNance 2,000
17. p_davis 2,000
17. REA_AN... 2,000
17. renjurdevan 2,000
17. cottsak 2,000
17. ad5qa 2,000
17. irps20001 2,000
17. Koocurrent 2,000
17. Rahu_ket... 2,000
17. ajitha75 2,000
17. Smart_Man 2,000

1. naspinski 52,450
2. Fernando... 44,300
3. sjturner2 20,250
4. CarlVerret 17,064
5. Ceiled 12,500
6. CMYScott 5,750
7. TheLearn... 5,172
8. Praesidium 4,664
9. GreenGho... 4,150
10. VBRocks 4,000
11. emoreau 3,050
12. gardavis 3,000
12. Dhaest 3,000
14. ZachSmith 2,600
15. mark_wills 2,500
15. boag2000 2,500
17. IndianOcean 2,000
17. Koocurrent 2,000
17. ajitha75 2,000
17. Rahu_ket... 2,000
17. p_davis 2,000
17. michtsoi 2,000
17. primeMov... 2,000
17. renjurdevan 2,000
17. ad5qa 2,000
17. SwissKnife 2,000
17. SteveH_UK 2,000
17. cottsak 2,000
17. vb_jonas 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. JimFive 2,000
17. AaronNance 2,000
17. REA_AN... 2,000
17. Smart_Man 2,000
17. irps20001 2,000

06.17.2008 at 05:43AM PDT, ID: 23491224

	[x] Attachment Details

Linq to XML issues

Asked by alan_ITG in Language Integrated Query - LINQ

Tags: Linq to XML VB.Net, Internet Explorer 6.0

Hi,

I am trying to import an MS Excel XML document (2003 version of XL).

The code being used is as shown.

The issues I have are as follows:-

1) The For Each R in Sheet....<Row> section works fine and iterates through the rows in the document.
However, when the code reaches the Linq query (even when the loop is commented out) the Linq query returns a NULLReference Error.

Any ideas why?

2) Often when setting up Linq queries the variable in the for each loop (x in this case) used to iterate through the Linq query results generates an error in VB. The error states that the variable has not been defined.

I believe that these variables do not have to be defined as they are anonymous types. Can someone advise why this error happens?

regards,

Alan

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:

           
           
             Imports System.Reflection
Imports System.IO
Imports <xmlns="urn:schemas-microsoft-com:office:spreadsheet">
Imports <xmlns:o="urn:schemas-microsoft-com:office:office">
Imports <xmlns:x="urn:schemas-microsoft-com:office:excel">
Imports <xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
Imports <xmlns:html="http://www.w3.org/TR/REC-html40">
 
Public Class DoXml
 
 
Sub ProcessXMLFile
 
 
        Try
 
            Dim sheet As XDocument = XDocument.Load(fname)
	    'This works
            For Each R In sheet...<Row>
                Debug.Print(R.<Cell>(0).Value)
                Debug.Print(R.<Cell>(1).Value)
                Debug.Print(R.<Cell>(2).Value)
            Next
 
 
	    'This returns nullexception error
            Dim y = From d In sheet...<Row> _
            Let Source = d.<cell>(0) _
            Let SubSys = d.<Cell>(1) _
            Select _
             Source = Source.Value, _
             SubSys = SubSys.Value _
            Skip (1)
 
            For Each x In y
                iRowcount = iRowcount + 1
                Console.WriteLine("processing row: " & iRowcount & " : " & x.ToString)
            Next
 
        Catch ex As NullReferenceException
            'do nothing except report back
            console.writeline(vbTab & "No Records to load in " & FuncName)
 
        Catch ex As Exception
 
            Console.writeline(vbTab & "Error in LoadDespatchesXML: " & ex.Message)
 
        End Try
 
End Sub
 
End Class

           
         

Keywords: Linq to XML issues

	Title
1	How to strip whitespace from XML wit…
2	XML aware edit controls?
3	XSD Schema Element Value Text from …
4	How to use & in xml document
5	XML Data Islands and <ul>
6	XForms

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Linq to XML issues

Asked by alan_ITG in Language Integrated Query - LINQ

Tags: Linq to XML VB.Net, Internet Explorer 6.0

About this solution