Insert Query in C# with Special Characters

hi,

please try

insert into tablename values('"+textbox1.text.Replace("'","''")
+"','"+textbox2.text.Replace("'","''")
+"');

Replece you single quote to  two single quote.

hope this help.

If you want to insert the column values with ' character then you have to normally like this.

INSERT INTO Example(Name,Address) VALUES('YYY''s',50)

Based on that, you can workaround in asp.net

hi friend ,



for insert character you should follow like
insert into tablename values('aaa','bbb');
while getting control value you should write like
insert into tablename values('"+textbox1.text+"','"+textbox2.text+"');
wat will happen if the value of textbox1 is like ABCD's then while inserting it will be like 'ABCD's' and will throw exception.


if textbox1.text = ABCD's
then u can use this :
insert into tablename values('"+Regex.Replace(textbox1.text, "'", "''")+"','"+textbox2.text+"');

Hi friend,

for insert character you should follow like

insert into tablename values('aaa','bbb');

while getting control value you should write like

insert into tablename values('"+textbox1.text+"','"+textbox2.text+"');