Prev: TcpClient throws "invalid pointer address" exception on Server 2008
Next: Program Compatibility WITHIN VS2008 Pro?
From: Mervin on 8 Sep 2009 09:21
Can anyone provide sample code for simply inserting the xml from an XDocument
into a XML column in SQL Server?
Thanks in advance.
From: Mervin on 8 Sep 2009 14:30
I discovered the answer. If using a SqlDataSource on a FormView, within the
..aspx page change the Parameter type from Object to String. Then, set the
value of the XML column to the string of the XDocument value:
XDocument responseXML = XDocument.Load(tr);
e.Values["Response_Xml"] = responseXML.ToString();
> Can anyone provide sample code for simply inserting the xml from an XDocument
> into a XML column in SQL Server?
> Thanks in advance.