.net and XML

[joemal]

I am trying to build an XML file from an SQL2000 database to output it as a file. Can anyone help?

I have a pre defined standard of the XML output.

Thanks

 

[chiph]

Run your SQL query with the "FOR XML AUTO" clause. You'll get back a single string that has the results of your query as XML.

You can then use a standard StreamWriter object's Write() method to send it to a file.

Chip H.