Unclosed quotation mark after the character string

Try replacing any embedded single quotes with two single quotes:

"select * from Item where Item_Name like '" + GridViewItem.Rows[0].Cells[1].ToString().Replace("'", "''") + "'";

Sunny Sharma13y ago

Then you need to remove them otherwise it will break the statement causing not to work.
Try this:

"select * from Item where Item_Name like '" + GridViewItem.Rows[0].Cells[1].ToString().Replace("'","")+ "'";

shibasankar behera13y ago

Yes it is containing quotes inside...

Sunny Sharma13y ago

hi shibasankar,

check the value returned from GridViewItem.Rows[0].Cells[1].ToString() as it may contain any quotes inside.

HTH :)