title: Insert command VB does not actually insert data?
body: <p>I have the following code which adds a record to the DB. The code executes fine, however when I look in the DB, there is no data added! Any help greatly appreciated: </p>
  
  <pre class="lang-vb prettyprint-override"><code>Dim Con As SqlConnection
  Dim cmd As New SqlCommand
  Dim connstring As String
  connstring = "Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Assignment.mdf;Integrated Security=True;Connect Timeout=30"
  Con = New SqlConnection(connstring)
  Con.Open()
  cmd = New SqlCommand("Insert into Rota ([Id],[Monday],[Tuesday],[Wednesday],[Thursday],[Friday],[Saturday],[Sunday],[UserID]) Values('" &amp; chosen &amp; "','" &amp; mon &amp; "','" &amp; tues &amp; "','" &amp; wed &amp; "','" &amp; thur &amp; "','" &amp; fri &amp; "','" &amp; sat &amp; "','" &amp; sun &amp; "','" &amp; user &amp; "')", Con)
  cmd.ExecuteNonQuery()
  MsgBox("done")
  Con.Close()
  </code></pre>