How to retrieve data from XML using LINQ in VB.NET?

Question

I cannot find a way to get the values from an XML file using LINQ.

Here is the code:

Dim XMLDoc As XDocument = XDocument.Load(XMLPath)

Dim query = From ex In XMLDoc.Descendants.Elements("DSServer")
                Select New With
                    {
                    .svrname = ex.Element("ServerName"),
                    .BG = ex.Element("IsBG")
                    }

For Each t In query
    MsgBox(t.svrname.Value.ToString + " " + t.BG.Value.ToString)
Next

And here is the XML

<?xml version="1.0" standalone="yes"?>
<DSPaths xmlns="http://tempuri.org/DSPaths.xsd">
  <DSServer>
    <ServerName>test1Name</ServerName>
    <ServerIP>test1</ServerIP>
    <ServerPath>test1</ServerPath>
    <Destination>test1</Destination>
    <IsBG>true</IsBG>
  </DSServer>
  <DSServer>
    <ServerName>test2Name</ServerName>
    <ServerIP>test2</ServerIP>
    <ServerPath>test2</ServerPath>
    <Destination>test2</Destination>
    <IsBG>true</IsBG>
  </DSServer>
</DSPaths>

What am I doing wrong?

The code does not return anything...

I would assume that XMLDoc.Descendants.Elements("DSServer") doesn't return any value. So the problem should be before any LINQ. Have you tried removing (in the xml) or specifying (in the code) the namespace? — the_lotus
– the_lotus, Commented Nov 23, 2018 at 19:24
How can i do to specify the namespace? I tried removing the namespace in the XML file and it now works... but the thing is that my code writes the using an XSD file, so it enters the namespace in the XML. — InfiniteLoop
– InfiniteLoop, Commented Nov 23, 2018 at 19:28
I tried adding the following: Imports <xmlns="tempuri.org/DSPaths.xsd"> but the code returns nothing (I did put back the namespace in the XML) — InfiniteLoop
– InfiniteLoop, Commented Nov 23, 2018 at 19:38

the_lotus · Accepted Answer · 2018-11-23 19:40:11Z

1

If you can't remove the namespace from the xml, you'll need to specify the namespace in the query.

    Dim ns As XNamespace = "http://tempuri.org/DSPaths.xsd"

    Dim query = From ex In XMLDoc.Descendants.Elements(ns + "DSServer")
                Select New With
                {
                .svrname = ex.Element(ns + "ServerName"),
                .BG = ex.Element(ns + "IsBG")
                }

answered Nov 23, 2018 at 19:40

the_lotus

12.8k3 gold badges39 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to retrieve data from XML using LINQ in VB.NET?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related