DataSet: Nested Tables in XML

[=?Utf-8?B?RnJhbmsgVXJheQ==?=]

Hi all

I got some trouble with creating XML Files.

I have a DataSet with two tables (Calendar and holidays)
and a Relationship (Nested = true) between both tables ("name").

When I now write the XML I get:
<Static>
<Calendar>
<name>AED</name>
<holidays>
<name>AED</name>
<holiday>2008-12-08</holiday>
</holidays>
<holidays>
<name>AED</name>
<holiday>2008-12-10</holiday>
</holidays>
</Calendar>
</Static>

What I need is this:
<Static>
<Calendar>
<name>AED</name>
<holidays>
<holiday>2008-12-08</holiday>
<holiday>2008-12-10</holiday>
</holidays>
</Calendar>
</Static>

Does anybody knows how this can be done ??

Thanks a lot for any comments.

Best regards
Frank

[sloan]

DataSet xml is best used with relational tables...and not nesting.

You can use this trick if necessary:

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry


"Frank Uray" <Fr*******@discussions.microsoft.comwrote in message
news:01**********************************@microsof t.com...

Hi all

I got some trouble with creating XML Files.

I have a DataSet with two tables (Calendar and holidays)
and a Relationship (Nested = true) between both tables ("name").

When I now write the XML I get:
<Static>
<Calendar>
<name>AED</name>
<holidays>
<name>AED</name>
<holiday>2008-12-08</holiday>
</holidays>
<holidays>
<name>AED</name>
<holiday>2008-12-10</holiday>
</holidays>
</Calendar>
</Static>

What I need is this:
<Static>
<Calendar>
<name>AED</name>
<holidays>
<holiday>2008-12-08</holiday>
<holiday>2008-12-10</holiday>
</holidays>
</Calendar>
</Static>

Does anybody knows how this can be done ??

Thanks a lot for any comments.

Best regards
Frank