In MSAcess Database, Insert query to insert the character with apostrophe

Posted by Suryakavitha on Stack Overflow See other posts from Stack Overflow or by Suryakavitha
Published on 2010-03-09T10:26:10Z Indexed on 2010/03/09 10:36 UTC
Read the original article Hit count: 259

Filed under:

In MSAcess Database

Insert query to insert the character------> N'tetarnyl

i have a insert query

OleDbCommand cmd = new OleDbCommand("insert into checking values('" + dsGetData.Tables[0].Rows[i][0].ToString() + "','" + dsGetData.Tables[0].Rows[i][1].ToString()+ "')", con);

but it is showing me error...

syntax error (missing operator) in query expression

any idea??? how to write insert query to insert the N'tetarnyl (including apostrophe)

© Stack Overflow or respective owner

Related posts about msaccess