Problem with apostrophes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Schmitz - 14 May 2005 13:54 GMT

Hi,

I currently use ADO.net to write to an access database using the
ExecuteNonQuery function and SQL INSERT statements. The data I write mostly
consists of names - which results in some problems: When I try to write names
like "O'Connor" or "O'Neal" the call fails ('cause of the ' ).
So, is there any way to write strings that contain apostrophes to a db using
SQL statements?

Thanks
Peter

Reply to this Message

Mark Rae - 14 May 2005 20:24 GMT

> So, is there any way to write strings that contain apostrophes to a db
> using
> SQL statements?

Just replace all instances of a single apostrophe with a double apostrophe.

Reply to this Message

christian kuendig - 15 May 2005 09:29 GMT

a better aproach would be to use a parameter... (no chance for sql
injection)

SqlCommand cmd = new SqlCommand(connection, "UPDATE dbo.User set name =
@name WHERE id = @id");
cmd.Paramters.Add("@name", "O'Neil");
cmd.Parameter.Add("@id", (int)222);

let the wizard generate some code to persist a dataset (creating a data
adapter) and just go over this code

reards

Christian

>> So, is there any way to write strings that contain apostrophes to a db
>> using
>> SQL statements?
>
> Just replace all instances of a single apostrophe with a double
> apostrophe.

Reply to this Message

Problem with apostrophes

Free Magazines