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