produce a truly hierarchical xml

[News Server]

Any help appreciated.

I have two Access tables, customer and orders. I would like to create a
truly hierarchical xml file form the joined tables. I need to produce:

<Query1>
<Customer>
<Name>Bob</Name>
<Order>
<ID>1001</ID>
</Order>
<Order>
<ID>1002</ID>
</Order>
</Customer>
<Customer>
<Name>Helen</Name>
<Order>
<ID>2001</ID>
</Order>
<Order>
<ID>2002</ID>
</Order>
</Customer>
/<Query1>

Just exporting the joined query gives me.

<Query1>
<Name>Bob</Name>
<OrderNumber>1001</OrderNumber>
</Query1>
<Query1>
<Name>Bob</Name>
<OrderNumber>1002</OrderNumber>
</Query1>
<Query1>
<Name>Helen</Name>
<OrderNumber>2001</OrderNumber>
</Query1>
<Query1>
<Name>Helen</Name>
<OrderNumber>2002</OrderNumber>
</Query1>

Anybody have a routine or references to produce a truly hierarchical xml
file for a joined relational database.

Thank you,
DJ

[Teemu Keiski]

Hi,

Load both tables separately as DataTables into DataSet. Then create a
DataRelation between the DataTables. And be sure to set DataRelation's
Nested property to true. After you have done this, get the XML out from
DataSet by using GetXml or WriteXml methods.

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist

"News Server" <da****@bhpeng.com> wrote in message
news:na*****************@newssvr24.news.prodigy.co m...

Any help appreciated.

I have two Access tables, customer and orders. I would like to create a
truly hierarchical xml file form the joined tables. I need to produce:

<Query1>
<Customer>
<Name>Bob</Name>
<Order>
<ID>1001</ID>
</Order>
<Order>
<ID>1002</ID>
</Order>
</Customer>
<Customer>
<Name>Helen</Name>
<Order>
<ID>2001</ID>
</Order>
<Order>
<ID>2002</ID>
</Order>
</Customer>
/<Query1>

Just exporting the joined query gives me.

<Query1>
<Name>Bob</Name>
<OrderNumber>1001</OrderNumber>
</Query1>
<Query1>
<Name>Bob</Name>
<OrderNumber>1002</OrderNumber>
</Query1>
<Query1>
<Name>Helen</Name>
<OrderNumber>2001</OrderNumber>
</Query1>
<Query1>
<Name>Helen</Name>
<OrderNumber>2002</OrderNumber>
</Query1>

Anybody have a routine or references to produce a truly hierarchical xml
file for a joined relational database.

Thank you,
DJ