Tiny MCE: Load from database and save into database

Friends,

I want to save the content into the database from tinymce and load the content from database. Pls help me.

Suresh v

vagaisuresh said:

user="suresh v"]

Friends,

I want to save the content into the database from tinymce and load the content from database. Pls help me.

Suresh v

 

Hello Suresh,

Try to do it like this.....In the markup write this

 <textarea id="txtTinyMCE" runat="server" name="txtTinyMCE" style="width: 95%; vertical-align: top; height: 400px;"></textarea>

and at cs side you just need to do it like this.

var test= new Test();
test.TinyMCEBody = txtTinyMCE.Value;
test.Name=txtName.Text;
...
...
...

add other properties and then save it to DB. Finally save it in DB by calling the AddNew() method. This is just an example.

TestRepository.AddNew(test);

For retreival you can do it like this.

string testID= Request.QueryString["testID"];

Test test= TestRepository.GetDetail(Convert.ToInt32(testID));

txtTinyMCE.Value = test.TinyMCEBody ;

I hope this is what you were looking for.

Thanks,

Sumit Arora

SumitArora said:

user="Sumit Arora"]var test= new Test();

Hello Sumit Arora,

I am using VS2005. Not support for var in this version. Is any alternate method available?

Suresh

vagaisuresh said:

user="suresh v"]

 

SumitArora said:

user="Sumit Arora"]var test= new Test();

Hello Sumit Arora,

I am using VS2005. Not support for var in this version. Is any alternate method available?

Suresh

Hello Suresh,

You can simple write it as :

Test test=new Test();

Thanks,

Sumit

Hello Friends,

Thanks. I found the solution with some research from above posts. But I have a problem during save the condent in Text Datatype.

                using (SqlCommand Cmd = DBConn.CreateCommand())
                {
                    Cmd.CommandText = "Insert into TEMPS (TempCode, TempHtmlBody) values (@TempCode, @TempHtmlBody)";

                    SqlParameter pTempHtmlBody = new SqlParameter("@TempHtmlBody", SqlDbType.Text, 16);
                    pTempHtmlBody.Value = TempHtmlBody;
                    pTempHtmlBody.Direction = ParameterDirection.Input;
                    Cmd.Parameters.Add(pTempHtmlBody);

Sixteen characters only saved.

Suresh

I required to save more than 8000 characters.

SqlParameter pNewsDescription = new SqlParameter("@NewsDescription", SqlDbType.VarChar, 8000);

Thank you.

Problem fixed.

cmd.Parameters.AddWithValue("@enm", txtEName.Text.Trim());