A while back I asked about editing a literal using cute editor and saving the changes. I assumed that this was the main purpose of the tool. The samples allow you to edit the text and make changes, and when you update they are displayed, however - as soon as the page is re-loaded the text that is in the page_load event is redisplayed. I don't see the point in that. I had expected that the update would possibly update the HTML, with the new formatting.

I recieved  one response about this - suggesting that I would have to save the edited text to a database. Is this the only option? I wrote code to attempt that. I pull text from a SQL DB then change it in the editor and save. In order to save I put the new text - as a string - into SQL. The update fails - because of all the tags and quotes,etc. that is part of the formatted string.  1. Is this the only way that permanent changes are saved in this editor? 2. If so, what sort of syntax do you use to add the HTML formatted string to a SQL statement - so it will save it properly?

Thanks, Dave

This is the code that I experimented with.

public void Submit(object sender, System.EventArgs e)

string strCText, strDBConn, strSQL;

Literal1.Visible = true;

Editor2.Visible = false;

btnUpdate.Visible = false;

SqlConnection ObjConn = new SqlConnection( strDBConn );

SqlCommand ObjCmd = new SqlCommand(strSQL, ObjConn);

Hi Dave,

CuteEditor is an online web-based WYSIWYG HTML editor. It upgrades your simple text area to a rich-text edit box. So you still need a data source to save the formatted data. The CuteEditor will not save the data itself.

We use the Literal control to hold the data for demo purpose. When the user click the submit button, the page post back, the editor visibility is set to false and pass the data to the Literal control. The user can see the editing result. But when the new user click the page, he/she will get the dafault content we predefined.

It's not necessary for you to use Literal control at all.

Below are sample code I suggest you to use:

void Page_Load(object sender, System.EventArgs e)
{
   
   if(! this.IsPostBack )
   {
   	String content = "";    //you can get the data from your data source to populate the editor
	Editor1.Text = content;
   }
} 

public void Submit(object sender, System.EventArgs e)
 {
     Literal1.Text = Editor1.Text;
     strDBConn = ConfigurationSettings.AppSettings["ConnectionString"];

     SqlConnection ObjConn = new SqlConnection( strDBConn ); 
     ObjConn.Open();
     strSQL = "UPDATE CText SET CTextContent = "+ Editor1.Text +" where CTextId = 1";
     SqlCommand ObjCmd = new SqlCommand(strSQL, ObjConn);
     objCmd.ExecuteNonQuery();
     ObjConn.Close();
 }<!-- Inject Script Filtered --><!-- Inject Script Filtered --> 

 If you have any further question, feel free to tell us.