read nested xml into a dataset

Question

I have an xml file with nested nodes - i want to populate a dataset with those rows from the .xml file which have roleid=124
use of .xsl or .xslt is not allowed.

<?xml version="1.0" encoding="utf-8"?>
 <reports>
  <report>
   <group>Administration</group>
   <reportname>Portfolio Summary Reports</reportname>
   <roles>
    <roleid>129</roleid>
    <roleid>124</roleid>
   </roles>
  </report>

  <report>
   <group>Finance</group>
   <reportname>General Ledger Reports</reportname>
   <roles>
    <roleid>129</roleid>
   </roles>
  </report>

  <report>
   <group>Support</group>
   <reportname>Legal Entity Reports</reportname>
   <roles>
    <roleid>124</roleid>
   </roles>
  </report>
  <report>
   <group>Market</group>
   <reportname>Market Summary Reports</reportname>
   <roles>
    <roleid>124</roleid>
    <roleid>130</roleid>
   </roles>
  </report>
 </reports>

 thanks a lot for your help