how to store text of text area to database

Question

hi sir........is it possible to store text of text area into database? if yes..please suggest me with sample example..

Sanjeeb Lenka · Answer

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

Jignesh Trivedi · Answer

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.

Iftikar Hussain · Answer

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.