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(); Mervin "Mervin" wrote: > Can anyone provide sample code for simply inserting the xml from an XDocument > into a XML column in SQL Server? > > Thanks in advance. |