How to add a CR LF on SQL Server field and show as a new line in C# textbox
Posted on 2009-12-20
I need to show in C# windows forms , in a multiline textbox I need to show the CR + LF that is stored in field.
In SQL Server I added the lines by doing the following
Update Table1 Set
COmment = comment + ' ' + char(13) + char(10) + @Comment
However when I view it in the C# , it becomes one line, what do I have to do to make it work?
Any help will be great.