How to INSERT "multilined textbox" to 1 column in SQL Server?

Question

I have a multilined textbox on my Winform. I want to INSERT it into my column in SQL Server. Does this automatically add the new lines into my column? Or is this even possible? BTW NVARCHAR(MAX) is the datatype of my column.

Yes just use the '.Text' property of the textbox – Cujoey Feb 02 '19 at 18:20 — Cujoey, Feb 02 '19 at 18:20

score 0 · Answer 1 · answered Feb 02 '19 at 18:18

0

The NVARCHAR(MAX) saves row breaks and should work with multilined textbox. See here for an example.

answered Feb 02 '19 at 18:18

ZarX

1,096
9
17

It doesn't have to be a `MAX`, any length `(n)(var)char` can store the characters for a Carriage Return (ASCII code 13) and a Line Break (ASCII code 10). – Thom A Feb 02 '19 at 18:41

score 0 · Answer 2 · answered Feb 03 '19 at 21:45

It should be no different than any other text insert -- it's just that this text may (or may not) contain newline characters:

using (SqlCommand cmd = new SqlCommand(
    "insert into MyTable (BigTestField) values (@TEXTBOX_DATA)", conn))
{
    cmd.Parameters.Add(new SqlParameter("@TEXTBOX_DATA", SqlDbType.NVarChar));
    cmd.Parameters[0].Value = textbox.Text;

    cmd.ExecuteNonQuery();
}

How to INSERT "multilined textbox" to 1 column in SQL Server?

2 Answers2