Hi shahbazkh,

Refer below link.

Save MultiLine TextBox value in Database with Line Break using C# in ASP.Net

this code npt wroking bru?

Please share your code that you have written.

Hi 191464,

Check this example. Now please take its reference and correct your code.

SQL

CREATE TABLE Demo(NEWLINE NVARCHAR(MAX))

HTML

<asp:TextBox ID="txtValue" TextMode="MultiLine" Rows="5" runat="server" />
<br />
<asp:Button ID="btnSubmit" Text="Submit" OnClick="Insert" runat="server" />
<br />
<br />
<asp:Label ID="lblMessage" runat="server" />

Namespaces

C#

using System.Configuration;
using System.Data.SqlClient;

VB.Net

Imports System.Configuration
Imports System.Data.SqlClient

Code

C#

protected void Insert(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    string query = "INSERT INTO Demo VALUES(@textboxValue);SELECT NEWLINE FROM Demo";
    SqlCommand cmd = new SqlCommand(query, con);
    con.Open();
    cmd.Parameters.AddWithValue("@textboxValue", txtValue.Text.Replace(Environment.NewLine, "<br />"));
    SqlDataReader sdr = cmd.ExecuteReader();
    while (sdr.Read())
    {
        lblMessage.Text = sdr["NEWLINE"].ToString();
    }
}

VB.Net

Protected Sub Insert(ByVal sender As Object, ByVal e As EventArgs)
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim con As SqlConnection = New SqlConnection(constr)
    Dim query As String = "INSERT INTO Demo VALUES(@textboxValue);SELECT NEWLINE FROM Demo"
    Dim cmd As SqlCommand = New SqlCommand(query, con)
    con.Open()
    cmd.Parameters.AddWithValue("@textboxValue", txtValue.Text.Replace(Environment.NewLine, "<br />"))
    Dim sdr As SqlDataReader = cmd.ExecuteReader()
    While sdr.Read()
        lblMessage.Text = sdr("NEWLINE").ToString()
    End While
End Sub

Screenshots

The web Form

Database after Insert