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...
 
Back
Top