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

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.
 
M

Mike Berro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot seem to update underlying DataAdapter with Values in Datagrid 3
Can't Make Primary Key Column Invisible in DataGrid? 6
Using Leave event to trigger an Update in Datagrid 1
Need to update dataadapter from datagrid that doesn't contain field 3
Data binding ComboBox, DataGrid 1
Viewing DataAdapter in Dataset at design time 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Data binding combo box with a datagrid 2

Top