Information générale
Titre:
Where and how store a XML?
Versions des environnements
Hi,
The question - where and how store the XML in SQL database ..
For example.. in FoxPro I can easy to save XML file in Memo Binary and easy extract it. So I need someting as MEMO field on SQL Server.
The SQL Server has a type SqlXml.. - is this type using to store XML content on SQL Server?
How to save and extract it?
Is this way is correct
Dim loXML as XMLDocument = new XMLDocument
loXML.load("c:\myxml.xml")
Dim lcXML as String = loXML.innerXML
and then not possible to store this text in the Sqlxml field.
Where is mistake in my thoughts...
P.S. the task is simple.. like in foxpo.. find the record, extract xml text.. and extract information from xml.
Thanks
Denis
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement