title: How do I get around the "'" problem in sqlite and c#?
body: <p>I'm working in Microsoft Visual C# 2008 Express with Sqlite.</p>
  
  <p>I understand that an apostrope (') in my text has problems in a query.  My problem is that I thought I could replace it with \'.  It doesn't seem to be working... Here's a parred down example of my code:</p>
  
  <pre><code>string myString = "I can't believe it!";
  cmd.CommandText = "Insert into myTable (myid,mytext) values (1,'" + myString.Replace("'","\\'") + "');";
  </code></pre>
  
  <p>The error I get is:
  SQLite error:
  near "t": syntax error</p>
  
  <p>I've tried a couple other replacements... like the other slash.  And I wrote my string and a replaced version of my string out to the console to make sure it was coming out right.  </p>
  
  <p>What stupid error am I making here?</p>
  
  <p>Thanks!</p>
  
  <p>-Adeena</p>