从数据库中检索文本并将其显示为HTML段落 [英] Retrieve Text From Database and display it as HTML paragraph

问题描述

我有一些文本存储在数据库中，我希望将其显示为html段落，有没有办法使用asp.net？



这里是我为数据库添加文本所做的：

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:

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:

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想要它作为段落而不是文本框。

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

推荐答案

参考这个.. :)



RichTextBox概述 [ ^ ]

refer this.. :)

RichTextBox Overview[^]

您可以尝试这样的事情：

You can try something like this :

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

最好运气：）

Best of Luck :)

将此添加到您想要显示段落的HTML中：

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

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

从page_load填充段落：

Populate the paragraph from the page_load with:

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

这篇关于从数据库中检索文本并将其显示为HTML段落的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！