How to build hierarchical XML from DataSet Options

[gamesforums]

Hi!

I need to build the following XML structure in my businnesslayer in
VB.NET.


<ProductionDataExtract>
<Region region="South">
<MonthToDate>
<ProductionBudget>2338</ProductionBudget>
</MonthToDate>
</Region>
</ProductionDataExtract>


My problem is that when i use DataSet.getXML() i will get a flat file
structure on the xml returned.


What I want is the following:
<ProductionDataExtract> (Root node, parent)
<Region> (child node of ProductionDataExtract, but parent to
MonthToDate)
<MonthToDate> (child node of Region, but parent to ProductionBudget)
<ProductionBudget> (child node of MonthToDate)


I have tried using ADO.NET's DataRelation Object, but of course this
wont work as I have no Key's between the parent and child elements.


So any suggestion are really appreciated!


Regards,
Mcad