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

"John Edens" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>