XMl File embeded in SQL to C# Program



I am making a program in C# that will read data from a SQL database. The data is stored in a XML file within the SQL Database. The column is a XML data type.


Is there a way to import the XML document from SQL to the C# program? I need it as a XML file because the program will go through the nodes and adjust data, overwrite it, and re-enter it into the Database.


I am using Microsoft SQL Server 2008 R2. Visual Studio 2010 is the IDE for the C#.


No comments:

Post a Comment