Generate a XML file from SQL Serve table's data?

[chand10]

Hi I am trying to generate a XML file from a SQL Server table's data in a formatted way. I'm struggling to start. Please suggest me an example.

I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison Thank u Chandu

[N a v a n e e t h]

chand10 wrote:

I am trying to generate a XML file from a SQL Server table's data in a formatted way.

select * from tablename for XML auto

This will give you XML output. Get this into a dataset and use dataset's WriteXML method to write it to XML file.

---

My Website | Ask smart questions