shibasankar behera

shibasankar behera

  • NA
  • 117
  • 101.3k

Unclosed quotation mark after the character string

Oct 9 2013 3:10 AM
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...

Answers (4)