in memory generated XML contains \r\n characters

EDN Admin · Aug 21, 2006

Hi all,
Im trying to serialize a tree object as XML and then persist the XML (in memory) into a SQL table.Im using the code below to generate the XML, a sample piece of generated XML is :
"<?xml version="1.0" encoding="utf-8"?><DTreeNodeOfOBSTeam xmlns:xsi="<a title="http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema rn http://www.w3.org/2001/XMLSchema rn
.... "
if you note youll see 1- the whole text is wrapped in double quotes and it has rn characters. these make the string unreadable for my stored proc which accepts a text parameter to update the table. I assume I can solve this by removing the double quotes and rn characters but I dont know how! Please let me know how I can fix this issue or if Im doing anything wrong.
Thanks,
Code used to generate XML:

System.Xml.Xsl.XslCompiledTransform transformer = new System.Xml.Xsl.XslCompiledTransform();
 transformer.Load(mPath);
MemoryStream msOut = new MemoryStream();
MemoryStream msIn = new MemoryStream(); 
m_data.ExportToMem(msIn);
msIn.Position = 0;
XmlReader xmlIn = XmlReader.Create(msIn);
xmlIn.MoveToContent();
transformer.Transform(xmlIn, null, msOut);
msIn.Close();
xmlIn.Close();
byte[] bytes = msOut.ToArray();
string transformedXml = Encoding.UTF8.GetString(bytes); 

msOut.Close();


View the full article

in memory generated XML contains \r\n characters

EDN Admin

Well-known member