ASP.Net Text with LineBreak from Multi-Line-TextBox to save in a database

asp.net string ntext
PassionateDeveloper picture PassionateDeveloper · Feb 3, 2011 · Viewed 37.8k times · Source

I have PrivateMessage-System in my new Community-Page.

I have a Multiline-Textbox for the Text of a private message. I save this text in a string, this string in a ntext SQL-Coloumn. I read this text from the ntext SQL-Coloum in a string and show it in a label.

When I have 5 linebreaks with the "Enter"-Key in my Multi-line-textbox, the linebreaks will disappeared in the label.

I don't know where they gone lost and what I am doing wrong. any idea?

Answer

JK. picture JK. · Feb 3, 2011

First of all is it actually saving the line breaks to your table? If so, what does it save them as, eg \r\n or CRLF or what?

Your label outputs html, so the only thing that will create a break is a <br /> tag. So you need to find and replace whatever is saved in the database:

Label1.Text = someDatabaseText.Replace("\r\n", "<br />");

Or even better, do the .Replace() before you save it to the database:

someDatabaseField = TextBox1.Text.Replace("\r\n", "<br />");

Related questions

Convert JSON String to JSON Object c#

I have this String stored in my database: str = "{ "context_name": { "lower_bound": "value", "upper_bound": "value", "values": [ "value1", "valueN" ] } }" This string is already in the JSON format but I want to convert it into a JObject or JSON Object. …

Read More
How to get the first five character of a String

I have read this question to get first char of the string. Is there a way to get the first n number of characters from a string in C#?

Read More
Convert string to List<string> in one line?

I have a string: var names = "Brian,Joe,Chris"; Is there a way to convert this to a List<string> delimited by , in one line?

Read More