save an xml document as a string

[abehm]

Hello,
I am trying to save an entire xml document as a string and then insert it to a sql server db as an xml data type. The problem is when I read the xmldocument to the string, somewhere along the way "\"'s are inserted in front of the attribute values in the xml. Can anyone help me?

         if (File.Exists(file))
         {
             XmlDocument mydoc = new XmlDocument();
             mydoc.Load(file);
             xmlsrc = mydoc.OuterXml;
             return xmlsrc;
         }
 

sample file before :

<?xml version="1.0" encoding="utf-8"?>
<BusinessData>
  <Test ID="789-1">
    <Analysis Status="Complete" PassFail="False">
      <Element>1</Element>
    </Analysis>
  </Test>
</BusinessData>

sample file after:

<?xml version=\"1.0\" encoding=\"utf-8\"?>
<BusinessData>
  <Test ID=\"789-1\">
    <Analysis Status=\"Complete\" PassFail=\"False\">
      <Element>1</Element>
    </Analysis>
  </Test>
</BusinessData>

[abehm]

oh nevermind, i removed the first line of the xml and it now saves to the server.

[dorinbogdan]

Thanks for sharing the solution.
It may help other memebers.

Peace on you,
Dorin.

[somannar]

Hi,

I m looking for the same requirement in JAVA will you help me to send the code which may helps me to understand the way it is implemented.

thanks

Somanna R

[dorinbogdan]

Welcome to TheScripts TSDN...

Unfortunately, we cannot provide full source code (it's against site rules), but suggestions and small snippets.
And you are required to try yourself writing the code.
Please post your code and then will see what is wrong.

Thanks,
Dorin.