Update database

[Claudio]

I have a form where I want to include, update and delete data. After I
modify the data on a Datagrid I have to apply the updates
(SQLDataAdapter.Update()). I would like to know if there is a way to apply
the changes to the DataBase after each insert, update or delete command. I
am using a SQLConnection, a SQLDataAdapert and a DataSet to modify the
table.

 

[William Ryan]

If it's a bound grid, you can use a button to allow the user to commit
changes or cellchanged or any of the events associated with the grid.

If I set a cell to the name Bill, then it changes four time one for each
letter, so you'd be better off waiting until the change is finalized adn
then send it.

HTH,

Bill