Hello, I have an XML document stored in an SQL Server blob, and now I want to read the blob and transform it to XML (no problems there) and finally update one node value in the XML! How do I do that?
My program does the following:
1. I read the table "TableA", one of the columns is a blob "blobA"
2. I load the XML using CreateAndLoadFromStream(TableA.blobA));
3. I select the node I want to update using XMLRootNode.selectSingleNode('T8800/T8802');
4. Here is my problem. I don't know how to proceed! How do I modify the value in the node I have selected ('T8802')? and how do I "reload" the blob with the new value?
I appreciate any help.
My program does the following:
1. I read the table "TableA", one of the columns is a blob "blobA"
2. I load the XML using CreateAndLoadFromStream(TableA.blobA));
3. I select the node I want to update using XMLRootNode.selectSingleNode('T8800/T8802');
4. Here is my problem. I don't know how to proceed! How do I modify the value in the node I have selected ('T8802')? and how do I "reload" the blob with the new value?
I appreciate any help.