Retrieve Text From Database and display it as HTML paragraph

Question

5.00/5 (2 votes)

See more:

I have some text stored in a database and i want to display it as html paragraph, is there a way to do it using asp.net?

here is what i did to add text to database:

C#

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        
        if (txtAbout.Text.Length != 0)
        {

            string AboutText = txtAbout.Text;
         
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

            
            
           
            con.Open();
            SqlCommand cmd1 = new SqlCommand("INSERT into AboutUsData Values ('" + AboutText + "')", con);
            cmd1.ExecuteNonQuery();
            con.Close();

as to retrieve it is the question:

C#

protected void Page_Load(object sender, EventArgs e)
   {
       SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
       con.Open();


       SqlCommand com = new SqlCommand("SELECT * from AboutUsData", con);
       SqlDataAdapter da = new SqlDataAdapter(com);
       DataSet ds = new DataSet();
       da.Fill(ds, "AboutUsData");



      TextBox1.Text = ds.Tables["AboutUsData"].Rows[0]["About"].ToString();
       con.Close();


   }

i want it to be as a paragraph instead of textbox.

Posted 29-Jul-14 3:07am

AlaaHalabi

Updated 29-Jul-14 3:20am

v2

Add a Solution

Comments

Leo Chapiro 29-Jul-14 9:13am

What have you already achieved? Show your code please.

AlaaHalabi 29-Jul-14 9:21am

i have updated the question with code :)

4 solutions

Solution 1

refer this.. :)

RichTextBox Overview[^]

Posted 29-Jul-14 3:15am

Nirav Prabtani

Solution 4

Just create a paragraph tag and make it as runat="server", and call it in your codebehind page. you can treat that paragraph tag as a server control now.
Cheers

Posted 29-Jul-14 18:17pm

Sibeesh Venu

Updated 29-Jul-14 18:18pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shibusen · Accepted Answer · 2014-07-29T03:24:00

Solution 2

You can try something like this :

C#

string strAbout = ds.Tables["AboutUsData"].Rows[0]["About"].ToString();
strAbout = "<p>" + strAbout + </p>
//Take a label
lblAbout.Text = Server.HtmlDecode(strAbout );

Best of Luck :)

Posted 29-Jul-14 3:24am

shibusen

Updated 29-Jul-14 3:30am

v2

Comments

Raje_ 29-Jul-14 9:32am

+5

shibusen 29-Jul-14 9:37am

Thanks Raje

AlaaHalabi 29-Jul-14 9:51am

You are a hero! Thanks a lot! :)

shibusen 29-Jul-14 9:54am

Thanks AlaaHalabi

David Rush · Accepted Answer · 2014-07-29T03:47:00

Solution 3

Add this to your HTML where you want the paragraph to appear:

<p id="paragraph" runat="server"></p>

Populate the paragraph from the page_load with:

C#

this.paragraph.InnerText = "This is a test of dynamicly adding paragraph text";

Posted 29-Jul-14 3:47am

David Rush

Comments

AlaaHalabi 29-Jul-14 9:56am

Excellent! This is exactly what im looking for! Thank you for your help. :)