StrataFrame Forum
Back
Login
Login
Home
»
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
Post Reply
Like
0
How to save a Xml-File on SQL-Server
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Rainer Kempf, RK
Rainer Kempf, RK
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 55,
Visits: 1.4K
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 :
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
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)
The XML Datatyp can be only compared or sorted with the is null operator.
what did i wrong ???
Thanks
Rainer
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
How to save a Xml-File on SQL-Server
Rainer Kempf, RK
-
15 Years Ago
This will be impossible to tell without a sample and the actual XML...
Trent L. Taylor
-
15 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search