ASP.NET Save Formatted text in SQL

Question

I have the following textbox:

<asp:TextBox  ID="txtText" runat="server" Height="135px" 
    Width="355px" TextMode="MultiLine"></asp:TextBox><br /><br />

how can I save the formatted text (text with line spacing mostly) and display it in another div/label or save it in database?

I tried to save it database using both nvarchar or text data but text is being passed as a one liner all the time.

data but text is being passed as a one liner all the time. How exactly did you verify this? — asawyer
– asawyer, Commented Oct 16, 2013 at 13:30
@asawyer breakpoints and assiging the texbox text to div/label directly on button click — rikket
– rikket, Commented Oct 16, 2013 at 13:42

rikket · Accepted Answer · 2013-10-16 14:13:39Z

1

Solved this by saving the text in a string and replacing \r\t with <br/> before saving to the database:

string text = txtText.Text;
text = text.Replace("\r\n", "<br/>");
//save to database

answered Oct 16, 2013 at 14:13

rikket

2,4179 gold badges49 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1