line break - xml

[pelican]

I've posted earlier about line break. I've realise what is the problem.

I have a text string. "This is line one.[carraige return code]This is line two."
I capture it, insert into MSSQL.

Then, I retrieve it, export into xml document.

Import xml document.

Those line break does not seems to work anymore.

Probably due to export into xml.

Anyway that i can still preserve the line break (carraige return).

[Sgt-Peppa]

You need to post some code! Where does the \r\n get lost? Have you checked if its still there after you extracted the text from Database.
How do you 'export' it to an Xml Document and how does your Xml Document look? (Structure) How do you import the data back to c#,........

[pelican]

Eg. "This is Line 1.\r\nThis is Line 2"
Before exporting, c# will print out correctly,

This is Line 1.
This is Line 2

After the string, "This is Line 1.\r\nThis is Line 2" being export into xml.
and import back, output or print the string.... it is literally the string
"This is Line 1.\r\nThis is Line 2"

is there anyway to preserve the line break after xml export/import.
using replace \r\n with line break after xml export/import is not really a good idea.
because sometimes the real text might have \r\n that dont mean to be line break.