title: Checking if INSERT INTO statement was successful
body: <p>I am using a MS Access database as the backend of my VB.NET application. I am entering users details into the database using an INSERT INTO statement:</p>
  
  <pre><code>cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &amp; config("DatabasePath") &amp; ";")
  cn.Open()
  cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn)
  dr = cmd.ExecuteReader
  </code></pre>
  
  <p>Everything works, but I wanted to check if the data has actually been entered into the database. I have tried using:</p>
  
  <pre><code>cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &amp; config("DatabasePath") &amp; ";")
  cn.Open()
  cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn)
  dr = cmd.ExecuteReader
  If dr.Read() Then
      ' Blah
  End If
  </code></pre>
  
  <p>but obviously the insert statement doesn't return anything so this doesn't work. Any suggestions?</p>