# Problem to parse XML with Linq

**URL:** <https://forum.kirupa.com/t/problem-to-parse-xml-with-linq/319095>\
**Category:** programming\
**Created:** [February 8, 2011, 11:16pm UTC](https://forum.kirupa.com/t/problem-to-parse-xml-with-linq/319095 "2011-02-08T23:16:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![terryc](https://avatars.discourse-cdn.com/v4/letter/t/ea5d25/32.png) [@terryc](https://forum.kirupa.com/u/terryc)\
**Post date:** [February 8, 2011, 11:16pm UTC](https://forum.kirupa.com/t/problem-to-parse-xml-with-linq/319095/1 "2011-02-08T23:16:53Z")

</div>

Hi Kirupa and experts,

I am struggling with Link to SQL. I follow examples and get some good result.  
However I am face to a nasty xml and hope that someone can help me.

```auto

<root>
<MyItem Host="00155DFF045C" LastName="HOUSTON" FirstName="WHITNEY" >
    <TimeStamp ComputerTime="02/07/2011 - 21:41:53.715">
        <Group Name="Group1">
            <Variable ID="1001" Value="Happy" >
            </Variable>
        </Group>
        <Group Name="Group2">
            <Variable ID="2000" Value="Monday" >
            </Variable>
            <Variable ID="2001" Value="Tuesday" >
            </Variable>
            
        </Group>
        <Group Name="Group3">
            <Variable ID="3000" Value="January" >
            </Variable>
            <Variable ID="3001" Value="February" >
        </Group>
        <Group Name="Groupe4">
            <Variable ID="4001" Value="108.000000" >
            </Variable>
            <Variable ID="4002" Value="800" >
            </Variable>
        </Group>
        <Group Name="CustomGroup">
            <Variable ID="1001000" Value="1.000000" >
            </Variable>
        </Group>
    </TimeStamp>
</MyItem>
<MyItem>
...
...
</MyItem>
</root>

```

I get correctly info like {Host=“00155DFF045C” LastName=“HOUSTON” FirstName="WHITNEY} thanks to your tutorial.

But problem happens with the different group name.  
For example, how can I retrieve value of Variable ID=“4001” which belongs to “groupe4” ?

Thx for your help.