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