Vb.net linq query on xml data

Question

I'm pretty new in XML and LINQ. I've a XLM file like this:

<?xml version="1.0" encoding="utf-8"?>
<Headers  xmlns="http://tempuri.org/GridLayerSchema.xsd">
<Header>
    <Name>Layer0</Name>
    <Fields FieldID="FieldID0" FieldName="FieldNameAll" FieldPosition="0"FieldPositionStart="0" FieldLenght="254" FieldEnable="true" />
</Header>
<Header>
    <Name>Layer1</Name>
    <Fields FieldID="FieldID0" FieldName="JetPosition" FieldPosition="0" FieldPositionStart="0" FieldLenght="14" FieldEnable="true" />
   <Fields FieldID="FieldID1" FieldName="Owner" FieldPosition="1" FieldPositionStart="14" FieldLenght="14" FieldEnable="true" />
   <Fields FieldID="FieldID2" FieldName="Item" FieldPosition="2" FieldPositionStart="28" FieldLenght="3" FieldEnable="true" />
 </Header>
</Headers>

I need to explore the file in two ways.

First I need to carge a combobox itemsource property with the Header.name
Second I need to make a Datagrid header with the fiels of the select layer.

I've made a linq query for take the Name property, but dosn't work.

Dim xdoc As XDocument = XDocument.Load(My.Application.Info.DirectoryPath & "\Layers\Layers.xml")

    Dim query = From el In xdoc...<Headers>
                Select New Header With {.Name = el.@Name}
    For Each e In query
         HeadersCollection.Add(e)
    Next

I haven't errors, simply I haven't result. I'll hope to find in "e" the name of Header in XML, but the query get's nothing. — Gianfranco Vrech
– Gianfranco Vrech, Commented Nov 18, 2015 at 8:23

Rahul Singh · Accepted Answer · 2015-11-18 08:34:50Z

1

You will have to include the namespace of XML and you can find all the Header elements. This will give you the correct result:-

Dim ns As XNamespace = "http://tempuri.org/GridLayerSchema.xsd"
Dim query = From e1 In xdoc.Root.Elements(ns + "Header")
                    Select New With {.Name = e1.Element(ns + "Name").Value}

answered Nov 18, 2015 at 8:34

Rahul Singh

21.8k6 gold badges43 silver badges61 bronze badges

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

1 Comment

Gianfranco Vrech Over a year ago

Great! Work perfectly.

Collectives™ on Stack Overflow

Vb.net linq query on xml data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related