Tuesday, July 31, 2012

Asp.Net Free Rich Text Editor using NicEdit Editor - Insert Text Into Database

NicEdit is a Javascript Based, WYSIWYG Editor, here we shall see on how to get the text entered in the Editor and insert it into the Database. 





To see on how to integrate the editor with an Asp.net textbox refer to the post
 Asp.Net Free Rich Text Editor using NicEdit Editor - Simple Interface 

The editor gives the text in the textbox as HTML tags with all the formatting, we just need to fetch the text using the .text property and save the HTML Tags

txtDescription.Text

Let us consider the following Table structure; we shall store the content of the Rich Text Editor into this table.

The INSERT query is a simple query, and needs no alterations to handle the content of the Rich Text Editor

string strSql = "INSERT INTO Projects (ProjectName,ProjectDescription) VALUES (";
            strSql += "'" + txtName.Text + "',";
            strSql += "'" + txtDescription.Text + "')";
            //
            string strConn =ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
            objConn = new SqlConnection(strConn);
            objCmd = new SqlCommand(strSql,objConn);
            objConn.Open();
            objCmd.ExecuteNonQuery();
            objConn.Close();

One inserted the data in the table looks as follows.



Search Flipkart Products:
Flipkart.com

No comments: