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.
that with SqlDataAdapter to load data.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dmitriy Lapshin [C# / .NET MVP]
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
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
M
Michael Earls
+1 to #3
Michael Earls
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.