How to save RichText to database

[Ming_Lei]

I have another problem. IF I want to save RichText TextBox content into database and later retrieve it so that the fonts and colors of texts in it are preserved. How can I do it? I have tried to save .Text property which only perserves the text body but not the fonts and colors. Which property of the RichText should I be using??

 

- Thanks.

[PlausiblyDamp]

Use the RTF property rather than the Text property.

[Ming_Lei]

Can't save

 

I am trying to save .Rtf property to database which uses a text type field to store RichText content, but it failed to save. Code as follows:

====================================

string cmdstr = "insert into diary2 values('"+date+"', '"+DiaryTextBox.Rtf+"')";

OleDbCommand cmd = new OleDbCommand(cmdstr, conn1);

cmd.ExecuteNonQuery();

 

What is the problem?

 

- Thanks.

[Ming_Lei]

Thanks for the reply. I have checked on the web for solutions, and I have found it!!