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.

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

Answers (1)