sql

Question

am using nvarchar(200) in my tablemovie with col name moviname. when am entry i don't luve u.it gives run time error .that Incorrect syntax near 't'. Unclosed quotation mark after the character string ''. cmd = new SqlCommand(Select distinct hallcode from Det_movie where Flag='Y' and MovieName=' + movie + ' con); i think problem arises becz of whe it matches the movie name it get a extra ' within sring(don't) in MovieName=' + i don't+ ' so problem arise how to overcome this problem

Bhabani prasad Dash · Answer

i just simply paste 'I Don''t Luv U' in column but it show the error near i

Praveen Moosad · Answer

Yes. When you execute this command insert into movie values ('i don''t luve u') the record will be inserted as  i don't luve u

Bhabani prasad Dash · Answer

that means when i insert the moviename into table i just write 'i don''t luv u' instead of i dont luv u.

Praveen Moosad · Answer

The problem is single quote between the inserted record. You have to escape it by doubling it like this: insert into movie values ('i don''t luve u')

sql

Incorrect syntax near 't'.Unclosed quotation mark after the character string ''.

Incorrect syntax near 't'.
Unclosed quotation mark after the character string ''.