Problem querying xml file

I am attempting to query the xml file to return the Tasks using the following code which is not returning anything! Is it possible to use linq to query an xml file of this structure?

Code:
  Dim doc As XDocument = XDocument.Load(XMLDOCFILEPATH)
            Dim qList = From xe In doc.XPathSelectElements("//Tasks") _
                    Select New With { _
                            .TaskId = xe.Attribute("TaskId").Value, _
                            .Question = xe.Attribute("Question").Value, _
                            .Result = xe.Element("Result").Value, _
                            .Comment = xe.Element("Comment").Value _
                            }
            Me.DataGridView1.DataSource = qList. engineereventVCAtwork.xml
LVL 1
JoeBo747Asked:
Who is Participating?
 
Fernando SotoConnect With a Mentor RetiredCommented:
Hi JoeBo747;

Made some changes to your code. Also your XML document has a Namespace and you need to account for it in the query as shown below.

Fernando
Dim doc As XDocument = XDocument.Load(XMLDOCFILEPATH)

' You need to account for the Namespace in the document
Dim ns As XNamespace = "http://mycomp.co.uk/Sexton.xsd/v2"

Dim qList = From xe In doc.Descendants(ns + "Task") _
            Select New With { _
                    .TaskId = xe.Element(ns + "TaskId").Value, _
                    .Question = xe.Element(ns + "Question").Value, _
                    .Result = xe.Element(ns + "Result").Value, _
                    .Comment = xe.Element(ns + "Comment").Value _
                }

Me.DataGridView1.DataSource = qList.ToList

Open in new window

0
 
JoeBo747Author Commented:
Thanks Fernando thats great.
0
 
Fernando SotoRetiredCommented:
Not a problem, glad I was able to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.