MS SQL XML - hierarchical xml by DataSet()->WriteXml()

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

hierarchical xml by DataSet()->WriteXml()

gok

2005-09-01, 8:24 pm

I'm playing with web-based front-end for hierarchical db in mssql2K.
So far my tables have 3 levels. I'm wonder how to store such hierarchical
trees outside (xml format).
DataSet()->WriteXml() method uses "2D" or flat dataset. How to create
tree-like xml?
--
gok

Michael Rys [MSFT]

2005-09-02, 8:24 pm

You should look at either the FOR XML clause or the SQLXML 3.0 annotated
schemas.

Best regards
Michael

"gok" <gok@discussions.microsoft.com> wrote in message
news:43FC6F1B-AE18-4C77-80EB- 549712A95E2B@microso
ft.com...
> I'm playing with web-based front-end for hierarchical db in mssql2K.
> So far my tables have 3 levels. I'm wonder how to store such hierarchical
> trees outside (xml format).
> DataSet()->WriteXml() method uses "2D" or flat dataset. How to create
> tree-like xml?
> --
> gok

Sponsored Links