How to create xml file in disk location using SQL Server 2005 & C#...?
-
I have created an XML using sql in SQL Server 2005. I like to Save that XML as a File in a particular location on the disk. I want only C# to make it done... It would not be possible to create that file on the disk using SQL Server becoz, I haven't administrator permission for the Sql Server. if i use DataReader to get field value, than it's not return complete xml... what i have to do...?
-
I have created an XML using sql in SQL Server 2005. I like to Save that XML as a File in a particular location on the disk. I want only C# to make it done... It would not be possible to create that file on the disk using SQL Server becoz, I haven't administrator permission for the Sql Server. if i use DataReader to get field value, than it's not return complete xml... what i have to do...?
-
I have created an XML using sql in SQL Server 2005. I like to Save that XML as a File in a particular location on the disk. I want only C# to make it done... It would not be possible to create that file on the disk using SQL Server becoz, I haven't administrator permission for the Sql Server. if i use DataReader to get field value, than it's not return complete xml... what i have to do...?
Presumably you are not asking how to create a file on the SQL Server file system itself given that you do not have access to that file system. So.... Steps 1. Connect to SQL Server 2. Query for xml 3. Open file 4. Read xml 5. Write xml to file. 6. Continue 4 and 6 until all of the xml is read. 7. Close the connection and the file. The above are distinct parts of the total problem.