title: Updating Datagridview data using SQLite Database
body: <p>I'm having trouble updating data from a data grid view with the use of a button. The text is editable but the changes does not save to the SQLite database. any ideas? </p>
  
  <pre><code>    private void ProjectsAdmin_Load(object sender, EventArgs e)
      {
          // TODO: This line of code loads data into the 'seniorProjectsDataSet2.DataTable1' table. You can move, or remove it, as needed.
          this.dataTable1TableAdapter.Fill(this.seniorProjectsDataSet2.DataTable1);
      }
  
  
      private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
      {
          if (e.RowIndex == -1 || e.ColumnIndex != 3)  //ignore header row and any column that doesnt have file name
              return;
  
          var filename = dataGridView1.CurrentCell.Value.ToString();
  
          if (File.Exists(filename))
              Process.Start(filename);
  
      }
  
  
  
      private void updateData_Click(object sender, EventArgs e)
      {
  
          SQLiteConnection conn = new SQLiteConnection();
          dataGridView1.EndEdit();
  
          dataTable1TableAdapter.Adapter.Update(seniorProjectsDataSet.Tables[0]);
  
  
          for (int i = 0; i &lt; seniorProjectsDataSet.Tables[0].Rows.Count; i++)
          {
              seniorProjectsDataSet.Tables[0].Rows[i].AcceptChanges();
  
          }
  
      }
  }
  </code></pre>
  
  <p>}</p>