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

[Guest]

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]

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