How to enter paragraphs in ASP.NET page and storing in SQL Server

Question

Hi I have a requirement for my to enter almost 5 paragaphs of text in an ASP.NET page. What control should I use? How do I store these paragraphs in SQL and display it on the screen again? Thanks

Sandeep Pant · Answer

protected void btnSubmit_Click(object sender EventArgs e) { if(Page.IsPostBack) { try { SqlConnection con=new SqlConnection(@data source=.\SQLExpress;Attachdbfilename=|datadirectory|TextBoxDatabase.mdf;integrated security=true;user instance=true); con.Open(); SqlCommand cmd = new SqlCommand(INSERT Table1 (ParagraphText) VALUES (@paragraphvalues) con); cmd.Parameters.AddWithValue(@paragraphvalues Textbox1.Text.ToString()); cmd.ExecuteNonQuery(); con.Close(); Label1.Text = data stored on the server; } catch(Exception ex) { Label1.Text=ex.Message.ToString(); } } } protected void btnRetrieve_Click(object sender EventArgs e) { try { SqlConnection con = new SqlConnection(@data source=.\SQLExpress;Attachdbfilename=|datadirectory|TextBoxDatabase.mdf;integrated security=true;user instance=true); con.Open(); SqlCommand cmd = new SqlCommand(SELECT TOP 1 ParagraphText FROM Table1 con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { textbox2.Text += reader[0].ToString(); } con.Close(); Label1.Text = data stored on the server; } catch (Exception ex) { Label1.Text = ex.Message.ToString(); } } Enter Paragraph ID=Textbox1 TextMode=MultiLine Columns=200 Rows=20 runat=server> ID=btnSubmit Text=submit to server runat=server OnClick=btnSubmit_Click /> ID=btnRetrieve Text=Retrieve from server runat=server OnClick=btnRetrieve_Click /> ID=textbox2 TextMode=MultiLine rows=20 Columns=200 runat=server /> ID=Label1 runat=server /> This is just a rough view to get the above task completed you can improve this code to make it more meaningful.