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