Login or Sign up Help | Site Map
Connecting Tech Pros Worldwide

How to build hierarchical XML from DataSet Options

Question posted by: gamesforums@hotmail.com (Guest) on June 27th, 2008 07:07 PM
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
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
 
Not the answer you were looking for? Post your question . . .
183,961 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment
  • Didn't find the answer you were looking for?
    Post Your Question
  • Top Community Contributors