Creating XML file with many-to-many relations with a dataset

I need to retrieve data from sql sever db that contains link tables which
provide
many-to-many functionality. Than I need to convert this data to xml file
with nesting parent and child relations. The XML need not contain the link
tables only their function (relations).

Should I use the DataSet object and the DataSet.GetXml() method to this
purpose?
I would greatly appreciate an example preferably in C#.
(I have already seen examples with one-to-many, so please don't refer me to
such).

Thank you in advance.
Hilel.

Shock
Sun Sep 12 16:02:36 CDT 2004

hilel_d wrote:

> I need to retrieve data from sql sever db that contains link tables which
> provide
> many-to-many functionality. Than I need to convert this data to xml file
> with nesting parent and child relations. The XML need not contain the link
> tables only their function (relations).
>
> Should I use the DataSet object and the DataSet.GetXml() method to this
> purpose?
> I would greatly appreciate an example preferably in C#.
> (I have already seen examples with one-to-many, so please don't refer me to
> such).
>
> Thank you in advance.
> Hilel.

Hilel,

I am not an expert working with xml, but I would think you could do some
of this easier by using xsd. I don't know much about either, just
thought I might point you in a slightly other direction.

Shock