From MQ I get an xml document as datatype string that looks something like following


<root>
<child1>
<child2>
<name>DOnald></name>
<age>14</age>
<mail>[email protected]</mail>
</child2>
<child2>
<name>Goofy></name>
<age>66</age>
<mail>[email protected]</mail>
</child2>
</child1>
</root>


Now suppose I want to bind this string to a dataset, I want datasource (the table) to correspond to the child1 node, and the child2 nodes to be the rows of the datasource, and the name, age, mail to be the columns.


How should I do this? Im quite clueless at the moment....
/henrik