Add a new XmlElement to XmlNode

[Guest]

For an xml file, I can use XmlDocument to load it and use
XmlDocument.CreateElement and XmlNode.AppendChild functions to create and add
a new XmlNode to it.
For an xml data type in sql database, I can load it from database and assign
it to an XmlNode, how do I create and add a new XmlElement to it? There is
not document associated with it in this case and hence there is no creation
context?

 

[Guest]

Hi,
Yes you can easily manipulate xml datatype in sql server with XQuery.Tostart
with following link should help you:
http://www.codeguru.com/cpp/data/mfc_database/xml/article.php/c10515__2/
Search for following in google "c# manipulate xml datatype xquery " and you
will get further links
Hope this helps