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))


On Wed, 29 Nov 2006 22:04:58 +0100, "Fab" <no**@none.comwrote:

>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 !

--

Bits.Bytes.
http://bytes.thinkersroom.com

[Fab]

Thanks that works perfectly !

[Rad [Visual C# MVP]]

Awesome!

On Thu, 30 Nov 2006 11:41:19 +0100, "Fab" <no**@none.comwrote:

>Thanks that works perfectly !

--

Bits.Bytes.
http://bytes.thinkersroom.com