title: Insert To Access Database Not Working
body: <p>I have a problem inserting a row into a table. When I click the register button, the row is not in the database, but in Gridview, it shows the row is inserted. When I open the database after clicking the register button, Gridview removes or clones the new insert data. I have made many programs and have not seen this problem before!</p>
  
  <p>My code is below.</p>
  
  <pre><code> Dim conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Database1.mdb"
      Dim con As OleDbConnection = New OleDbConnection(conn)
      Dim query As String
      Dim adb As OleDbDataAdapter = New OleDbDataAdapter
      con.Open()
      query = "INSERT INTO Sell(Seller,Price) Values(11,10)"
      Dim cmd As New OleDbCommand(query, con)
      cmd.ExecuteNonQuery()
      DataGridView1.Refresh()
      con.Close()
  </code></pre>
  
  <p>The VB.NET compiler is not giving me an error and I'm not getting an error when I run the program.</p>
  
  <hr>
  
  <p>I'M change run as debug to run as release</p>