I am using Visual Studio 2012
Created / added database in "AppData" folder in VS 2012
Here is my code:
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString());
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT INTO MyDataTable (Storing_Data) VALUES (@Storing_Data)";
cmd.Connection = myConnection;
cmd.Parameters.AddWithValue("@Storing_Data", CKeditor.Text);
myConnection.Open();
cmd.ExecuteNonQuery();
myConnection.Close();
string str = CKeditor.Text;
string str1 = Server.HtmlEncode(str);
string str2 = Server.HtmlDecode(str);
...
Go to the complete details ...