line break [closed]

May i know is there anyway to store line break into MSSQL ?

Eg. I have a text string "This is my 1st line.\r\nThis is m 2nd line."

After i insert into db, then i retrieve out and display. It wont line break.
It show the whole actual string "This is my 1st line.\r\nThis is m 2nd line."


Please advise.
Thanks.

Do a replace on \n, and replace it with System.Environment.NewLine (assuming you're putting that into a textbox or the likes.)

Thanks.

I've realise my problem.

I am creating another thread.