title: VB.NET single quotation not accepted by query
body: <p>I have a database class. And I'm using SQLServerCe which will run all commands. I put my query into a string variable q. And pass into the function of Database class. I have a problem. All values are accepted. But when I put single quotation into textbox. Then it gives an error.....</p>
  
  <p>Here is my code :</p>
  
  <pre><code>Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click 
      Dim q As String = "insert into student_classes (student_class) values ('" &amp; TextBox1.Text &amp; "')" 
      db.execute(q) 
      MsgBox("Record Added Successfully") 
      TextBox1.Clear() 
  End Sub
  </code></pre>