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