Converting a SQL Server 2000 table into an XML file

[KNN]

I need to find a way to grab a table from the SQL Server 2000 and convert it into a structured XML file

really need this!

thanks

 

[ashishnaicker]

You can try the following steps:

1. Create a dataadapter and a dataset.
2. Use the dataadapter to fill the dataset with the contents of the table from SQL Server.
3. Use either the WriteXML(...) or WriteXMLSchema(...) method of the dataset to write a XML file.

Hope this helps.

I need to find a way to grab a table from the SQL Server 2000 and convert it into a structured XML file

really need this!

thanks

 

[KNN]

worked !

thanks