how to store text of text area to database

yadagiri uppari

13y13.4k.NET

hi sir........is it possible to store text of text area into database?

if yes..please suggest me with sample example..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,
yes it is possible to store text area 's text into data base.
this is same as store text box value in to data base. but for same you have to fix string length and according to this you have fix length of filed in database.
if you are SQL2005 and above user than you can also use Varchar(max).

hope this will help you.

Hi,
Yes, it is possible to store it. Please refer below example where I am saving Employee details in database.

I will be storing Employee First Name, Last Name and Address (which is a textarea)

In .aspx page

First Name
Last Name
Address

In code behind (.aspx.cs)
protected void BtnSave_Click(object sender, EventArgs e)

{

var firstName = TxtBxFirstNm.Text;

var lastName = TxtBxLastNm.Text;

var address = TxtBxDesc.Text.Trim();

try

{

using (SqlConnection conn = new SqlConnection(@"Data Source=SQLEXPRESS;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=password"))

{

if (conn.State == ConnectionState.Closed)

conn.Open();

string insertString = @"insert into EmployeesBackUp(FirstName,LastName, Address) values(@FirstName, @LastName, @Address)";

SqlCommand cmd = new SqlCommand(insertString, conn);

cmd.Parameters.AddWithValue("@FirstName", firstName);

cmd.Parameters.AddWithValue("@LastName", lastName);

cmd.Parameters.AddWithValue("@Address", address);

cmd.ExecuteNonQuery();

conn.Close();

Response.Write("Data is Saved");

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

}

Regards,
Iftikar

Please let me know if you need more information.

Remember to click "Mark as Answer" on the post, if it helps you.

Sanjeeb Lenka13y ago

check this link
http://stackoverflow.com/questions/16296695/asp-net-get-the-value-from-textarea

ex-
aspx page:

cs code to get the textarea value:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class textare : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text = Request.Form["txtImagename1"];
    }
}

check this you can pass this value to database also . check the bold letter line