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?
Insert SQL carriage return and line feed in a string In SQL Server, we can use the CHAR function with ASCII number code. We can use the following ASCII codes in SQL Server: Char(10) – New Line / Line Break. Char(13) – Carriage Return.
A multiline text box allows you to display more than one line of text in the control.
A multiline text box control is a large text box that can display several lines of text or accept this text from user input. Text boxes are often linked to select value lookups and detailed menus. You can place a multiline text box control within a section control.
You can solve this with CSS. Assign this CSS to your label:
white-space: pre-wrap;
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 />");
this also works:
lbl_PostContent.Text = lbl_PostContent.Text.Replace(vbCrLf, "<br />")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With