Problem to parse XML with Linq

programming
1

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.


<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.