title: Database not saving upon program exit
body: <p>I have the following code, which reads all data from a dataGridView, and supposedly saves it into a database.</p>
  
  <pre><code>private void datInp_Click(object sender, EventArgs e)
  {
      SQLiteConnection con = new SQLiteConnection("Data Source=dBase1.sqlite;Version=3;");
      con.Open();
      SQLiteCommand sqlDatBas = new SQLiteCommand("INSERT INTO table1(column1,column2) VALUES (@c1,@c2)", con);
      for (int i = 0; i &lt; dataGridView2.RowCount-1; i++)
      {
          sqlDatBas.Parameters.AddWithValue("@c1", dataGridView2.Rows[i].Cells[0].Value);
          sqlDatBas.Parameters.AddWithValue("@c2", dataGridView2.Rows[i].Cells[1].Value);
          sqlDatBas.ExecuteNonQuery();
      }
      con.Close();
      con.Dispose();
  }
  </code></pre>
  
  <p>However, whenever I run it, and use the program to display the current state of the database, it shows as if the data got saved, but, if I exit my program and run it again, it just displays the base database, without the newly added data. Is it because I am missing a column? As the table was created with an ID, but it's supposed to autoincrement. Below is how the table was created.</p>
  
  <p><code>CREATE TABLE "table1" ("columnID" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "column1" VARCHAR, "column2" VARCHAR)</code></p>
  
  <p>I always use <code>ExecuteNonQuery()</code>, after every passing of the loop so all data gets added to the database. I display the current state of the database in a dataGridView, and it shows the added items, but not when I restart the program. What am I missing?</p>