title: How to update database using dataset, tablemanager, and bindingsource?
body: <p>This is a pretty small program, so I just used the autogenerated code for my datasource and dragged/dropped a datagridview on my WinForm. I'm trying to manually update a column in a row, but it fails each time I get to the "UpdateAll" of my tablemanager. Here's my code for double click of cell content:</p>
  
  <pre><code>    private void dgv1DataGridView_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
      {
          try
          {
              string delMemberID = dgv1DataGridView.Rows[e.RowIndex].Cells[0].Value.ToString();
              ds1DataSet.Table1.Rows[ds1DataSet.Table1.Rows.IndexOf(ds1DataSet.Table1.FindByMemberID(delMemberID))][9] = MemberID.ToString();
              this.Validate();
              this.bs1BindingSource.EndEdit();
              this.tableAdapterManager.UpdateAll(this.ds1DataSet);
              MessageBox.Show("Replacement Successful");
              this.Close();
          }
          catch
          {
              MessageBox.Show("Replacement Failed");
          }
      }
  </code></pre>
  
  <p>My expectations are; when a user double clicks anywhere inside a row of the datagridview, it will update that row with a different "MemberID" for that column, save the data everywhere (including database), and then close the form (to return the parent form).</p>