SQL to XML

  • Thread starter Thread starter cfyam
  • Start date Start date
C

cfyam

How can I save data(query from SQL Server 2000) to XML file? If I don't do
that with SqlDataAdapter to load data.
 
Hi,

I see various options here

1) Install SQLXML and XMl data directly from the SQL Server
2) Use SqlDataReader, populate a dataset in a loop and then save the dataset
as XML
3) Use SqlDataReader, read data in a loop and save it to XML manually with
XmlWriter
 
+1 to #3

Michael Earls

Dmitriy Lapshin said:
Hi,

I see various options here

1) Install SQLXML and XMl data directly from the SQL Server
2) Use SqlDataReader, populate a dataset in a loop and then save the dataset
as XML
3) Use SqlDataReader, read data in a loop and save it to XML manually with
XmlWriter

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

cfyam said:
How can I save data(query from SQL Server 2000) to XML file? If I don't do
that with SqlDataAdapter to load data.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL query to XML 2
XML vs SQL Server 22
Store XML/XSD in SQL Server 2008 3
Saving a class as XML in SQL 4
Binding XML Data to WPF 1
Recordset load XML 4
Blob and XML 14
Query data (SELECT * FROM table) from XML File 9

Back
Top