Generate XML Question from

[DNB]

I need to Generate XML files related to some standard format.
Can someone letme know what is the best way to do.
As far as I know, it can be done in one of the following way :
* Through sql queries: but in our cases lots of data and tables are involved
and queries can be very complex
* Create an XmlDataDocument for the DataSet and display data

Thanks
DNB

 

[Nicholas Paldino [.NET/C# MVP]]

DNB,

If you need to generate XML of a standard format, then you should have a
schema.

Aside from that, how you generate the XML is dependent on where you are
getting the data from. If you are getting the data from SQL Server, then it
is most likely better to let the server create the XML for you from the data
(using the FOR XML syntax in your queries).

 

[DNB]

Thank..your reply was helpfull

--DNB

DNB,

If you need to generate XML of a standard format, then you should have
a schema.

Aside from that, how you generate the XML is dependent on where you are
getting the data from. If you are getting the data from SQL Server, then
it is most likely better to let the server create the XML for you from the
data (using the FOR XML syntax in your queries).


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I need to Generate XML files related to some standard format.
Can someone letme know what is the best way to do.
As far as I know, it can be done in one of the following way :
* Through sql queries: but in our cases lots of data and tables are
involved and queries can be very complex
* Create an XmlDataDocument for the DataSet and display data

Thanks
DNB