C# and database...

Hello all, i have built a message board system as part of a portal that we are making. I am however stuck at one part. Let's say i have a long string (which is the body of the message), and i'm sending this to a database...now, if this body contains "'" it will not insert it, becase the string gets cut off...how would i have to tell the sql statement to know that this is not the end of the string? i tried "\'" but that did not work either!


thanx for any help.

use "''" ---> use two single qouts instead of one..
Hope this works

Sonia:rolleyes: :eek:

excellent...thanx a lot sonia...your help is much appreciated.