Hi,

Im using C# and SQL Server. I'm trying to upload some text from a simple form and keep the formatting (ie: line breaks)

I have searched and search for this but cant find an answer anywhere. The only thing I can find is Replace(str,"\n","<br />")

but I specifically DONT want HTML in my database.

Does anyone have any ideas what I can replace the '<br />' with in the above statement? Thanks in advance,

Pete

You can store the data as-is in the database. But when you display the data in a webform as literal text, you'll ALWAYS have to change the hard returns with <br> otherwise it simply won't wrap.

Take a look at this very forum. This forum stores the text you enter in the textbox as-is in the database. You can verify this by simply editing an existing post. When the forum displays the message, it replaces the literal line breaks with HTML breaks so it displays correctly.