How to save a Xml-File on SQL-Server

Rainer Kempf, RK — Sat, 14 Mar 2009 11:56:03 GMT

Hi,

I have follwing probelm.

I have a table on sqlserver with a field of type XML

in BO i changed Datatype of this field to System.Data.SqlTypes.SqlXml

this is code for saveing XML on SQL-Server :

[codesnippet]

If File.Exists(LcFileName) Then

Dim loXMLDocument As XmlDocument = New XmlDocument
loXMLdocument.Load(LcFileName)
loXML = New SqlXml(New XmlTextReader(loXMLdocument.InnerXml, XmlNodeType.Document, Nothing))

GridConfigBo1.layoutxml = loXML

GridConfigBo1.Save()

End If

[/codesnippet]

When Record not exist on SQL-Server then Record will be saved.

Next time when i try to update XML-Field i got error message. (Translated error message)

[i]The XML Datatyp can be only compared or sorted with the is null operator.[/i]

what did i wrong ???

Thanks

Rainer

RE: How to save a Xml-File on SQL-Server

Trent L. Taylor — Sat, 14 Mar 2009 11:56:03 GMT

This will be impossible to tell without a sample and the actual XML data. When using an XML data type on SQL Server, you MUST have the xml properly formatted and provide a schema otherwise it will fail. The XML data type is pretty cool if you get it working as you can query within the XML string...however, this is not a forgiving data type. Why are you using the Xml data type instead of a VarChar or NVarChar fiield?

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How to save a Xml-File on SQL-Server

How to save a Xml-File on SQL-Server

RE: How to save a Xml-File on SQL-Server