Insert Query in C# with Special Characters

Question

I wriiten a insert query in C# and it works fine.But when i am trying to insert character like ' then its throwing exception.
Please let me know the correct way so that it should accept all characters.
Thanks

Jignesh Trivedi · Answer

hi please try insert into tablename values('+textbox1.text.Replace(''') +''+textbox2.text.Replace(''') +'); Replece you single quote to two single quote. hope this help.

Senthilkumar · Answer

If you want to insert the column values with ' character then you have to normally like this. INSERT INTO Example(NameAddress) VALUES('YYY''s'50) Based on that you can workaround in asp.net

charbel ghattas · Answer

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+');

Apurva Mehta · Answer

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.

Gomathi Palaniswamy · Answer

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+');