Unclosed quotation mark after the character string

Question

I am passing some query like this: select * from Item where Item_Name like ' + GridViewItem.Rows[0].Cells[1].ToString() + '; Item Name contains a single quote so when I am passing the above error is coming. Suggest me some answers... Thank You...

Vulpes · Answer

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 Sharma · Answer

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 behera · Answer

Yes it is containing quotes inside...

Sunny Sharma · Answer

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