tags:

views:

22

answers:

0

I want my dataset to generate xml that looks like this

<Bugs>
    <Bug>
     <Name></Name>
     <Desc></Desc>
     <Comments>
      <Comment></Comment>
      <Comment></Comment>
     </Comments>
    </Bug>
</Bugs>

I am returning 2 sets of data from a stored proc, one returns the "bug" data and the other "comments".

I then load them into 2 datatables and create a relation on the BUGID that is present in both sets of data.

Now when i do dsBugs.GetXml(); i get xml that looks like:

<Bugs>
    <Bug>
     <Name></Name>
     <Desc></Desc>
     <Comment></Comment>
     <Comment></Comment>
    </Bug>
</Bugs>

Is there a way without using XPath or XQuery to get my data set generate the xml that has the "comment" tag inside their parent element "Comments" ?

I am using Framework 2.0