title: vb.net error when im trying to insert 2 statement
body: <p>Below are my code use for update data in my database. So i can set my database status to true or false, (tick and not ticked in my database). then i need to add one more which is student id into the statement so when i insert the student id, i also insert and set the status in my database to true. when i type stundet id into the coding, it cannot run. but when i delete it and run the update accommodation status to true it will run. So i think there's problem in the stundent id part.</p>
  
  <pre><code>cmdUpdate.CommandText = "UPDATE Accommodation SET Status = True , Student_ID = '" &amp; txttp.Text &amp; "' WHERE Unit_ID = " &amp; txtunitid.Text &amp; ";" 
  </code></pre>