how to insert a name Ram's in Sql Server database

Before passing the value into SQL statement replace single quote with two single quote. like ' with '' and it will work.

However I would suggest to use the parameterized SQL statement rather than passing direct value into the SQL statement.

Look at this post where it has been demonstrated - http://www.itfunda.com/how-to-insert-records-into-the-database/Free/126

Using parameterized SQL Statement helps you to avoid SQL Injection as well.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

you make a function:

function string stringQuoReplace(string txt) {

Replace(txt,"'", "''")

}

and on ur sql statmnt, would look something like this:

text = stringSwap(text);

string SQL = "INSERT INTO tabel (First, Second, Third) VALUES (number, text, text)"

what that code does, is to replace ' with '' <-- 2 single quotes, not double quotes.

Best Regard's
Tiju Thankachan

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

try this....

insert into employee values ('c03','Ram''s')   //not a double quote. two single quotes

Thanks,

Nitha Deepak

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

Replace the single quote with Apostrophe
function string stringQuoReplace(string txt) {

Replace(txt,"'","`")

}

Thanks,
Sanjay

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

INSERT INTO CTEST VALUES('RAM''S')

REGARDS

sriram

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

CREATE TABLE Sample
( NAME VARCHAR(50) )

INSERT INTO Sample VALUES ('RAM')


Try this..

Ajay
ajaypatelfromsanthal.blogspot.in

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator

Repalce single quote with two single quote

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Mrutyunjay51, if this helps please login to Mark As Answer. | Alert Moderator