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

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" <(E-Mail Removed)> wrote in message
news:01343959-1765-44D8-B263-(E-Mail Removed)...
> 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
>