Save Rtf from a RichTextBox into Access

[Fab]

Hi,

How can I save the text edited in a richTextBox into a field of an Access
table.
I have an error using the following code:

OleDbCommand toto = new OleDbCommand("UPDATE Table1 SET Field1 = '" +
richTextBox1.Rtf.Replace("'","''").Trim() + "' WHERE id = 8"
toto.ExecuteNonQuery.

Field1 is a Memo type.

Thanks !

 

[Rad [Visual C# MVP]]

Hey Fab

You'll be saved a lot of grief if you used parameterized queries. Try
this:

OleDbCommand toto = new OleDbCommand("UPDATE Table1 SET Field1 = ?
WHERE id = 8");

toto.Parameters.Add(new OleDbParameter("@Field1",richTextBox1.rtf))

 

[Fab]

Thanks that works perfectly !

 

[Rad [Visual C# MVP]]

Awesome!

Thanks that works perfectly !