Friday, 6 September 2013

Select method from a datarow with single quote conflict C#

Select method from a datarow with single quote conflict C#

I recently found when I do a LINQ select under a field that contains an
apostrophe, it makes my application to throw an exception.
DataRow[] newDr = this.ds.Tables["TableName"].Select("Name = '" +
drData["Name"].ToString() + "'");
If drData["Name"] = "The business's money"
I got an exception of "Syntax error: Missing operand after 'S' operator "
Can anyone tell me how to preserve it and no replace it or remove it, please?

No comments:

Post a Comment