I have a xml file and in a node i have attribute name and on the bases of the name i have to select the text of the child node i am not geting the way so plz help me. the xml file is as

<?xml version="1.0"?>
<!--List of controls with their property settings-->
<SheetGroup >
<ControlSheet Name="Caption" Quantity="2">
<NewControl Name="NewControl0">
<Caption>country</Caption>
<Type>TextBox</Type>
<Value>Null</Value>
</NewControl>
<NewControl Name="NewControl1">
<Caption>hobby</Caption>
<Type>CheckBox</Type>
<Value>Null</Value>
</NewControl>
</ControlSheet>
</SheetGroup>



on the bases of name attribute in newcontrol i have to select the value against that.



thank you in advace!