How to build hierarchical XML from DataSet Options

Discussion in 'XML' started by gamesforums@hotmail.com, Jun 12, 2008.

  1. Guest

    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
     
    , Jun 12, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    453
  2. Cliff  Martin
    Replies:
    1
    Views:
    3,084
    Larry Smith
    Jan 31, 2007
  3. jacksu
    Replies:
    0
    Views:
    537
    jacksu
    Oct 9, 2007
  4. Replies:
    2
    Views:
    968
    Joseph Kesselman
    Nov 5, 2007
  5. sharan
    Replies:
    2
    Views:
    323
    Stefan Behnel
    Nov 16, 2007
Loading...

Share This Page