Good morning, sippyuconn
I agree with Arne. When we use NTEXT field to store XML string, it has no
difference from storing a normal string. We can read the XML file into a
string with the code:
StreamReader reader = new StreamReader("path to the xml file");
string xml = reader.ReadToEnd();
reader.Close();
and insert it into a SQL server table with Arne's code snippet.
Please let us if you have any other concerns or questions.
Regards,
Jialiang Ge (ji****@online.microsoft.com, remove 'online.')
Microsoft Online Community Support
=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
ms****@microsoft.com.
This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================