Quick LINQ to XML sample for Lambo

Lambo-LinqToXml.cs

XDocument doc = XDocument.Load("my-xml-file.xml");

foreach(XElement el in doc.Descendants("row")
{
   
   test.actual = el.Descendants("var").Where( x => (string)x.Attribute("name") == "account" ).Single().Attribute("value").Value;
   test.actual = el.Descendants("var").Where( x => (string)x.Attribute("name") == "commitment").Single().Attribute("value").Value;
   /* Repeat the above as need for additional 'var' element values */
}

my-xml-file.xml

<row> 
   <var name="budgetYear" value="2008" /> 
   <var name="account" value="0010" /> 
   <var name="actual" value="8241" /> 
   <var name="commitment" value="537" /> 
   <var name="costCentre" value="E2000" /> 
   <var name="internalCostCentre" value="101" /> 
</row> 
<row> 
   <var name="budgetYear" value="2008" /> 
   <var name="account" value="dodgy" /> 
   <var name="actual" value="8241" /> 
   <var name="commitment" value="537" /> 
   <var name="costCentre" value="E2000" /> 
   <var name="internalCostCentre" value="101" /> 
<row>