I have stored procedure created by a client that returns an XElement object. Below is the sample of the XElement object:

<Rows>
<row>
<Header SchoolNumber="0111" SchoolName="Technical Institute" Address1="123 Main Street" City="Washington" State="DC" Zip="10008" DirectorsName="Mr. John Smith"/>
</row>
<row>
<Detail DateTakenActual="2010-01-28T00:00:00" ID="11111" GradYear="2009" ExamineeSt="DC" OverallStatus="Fail" IStatus="Pass" RStatus="Fail" GStatus="Pass" IScore="461" RScore="384" GScore="410"/>
</row>
</Rows>

How do I go about parsing this and extracting the data (SchoolNumber, SchoolName, DateTakenActual, etc). Thank you so much in advance!