How best to update DataAdapter to make DataGrid update immediately like table in Access would

  • Thread starter Thread starter John Edens
  • Start date Start date
J

John Edens

Hey all,

What is the best Event to use to trigger a DataAdapter Update so that any
changes to the bound DataGrid are immediately updated to the underlying data
source?

Basically I want the VB datagrid to work in the same way the spreadsheet
view of a table in Access would work - enter a new value into the cell - the
underlying record is immediately updated. Same for entering a new record
into the DataGrid - would like an immediate update of the underlying data
source.
 
Probably using the RowValidated event. Access doesn't update the database
until you move off the row, or click the "row header", so that should
duplicate it. (I'm using the DataGridView in Net2.0; dunno if DataGrid
supports that event.)

---Mike
 
Back
Top