committing data on row delete for datagridview

I have a bound datagridview, and set the rowValidated event to call the .update command for the tableAdapter. This works great, however, when I delete a row by selecting the row and pressing delete, it does not call the rowValidated event obviously, so it does not commit, until and IF the user changes rows.. Should I change my logic to call the .update command on another event?

Thanks for your input.

Brandon
[431 byte] By [bjswift] at [2007-11-20 10:06:57]
# 1 Re: committing data on row delete for datagridview
You could handle the RowDeleted event of the DataTable. That said, is it really necessary to commit to the database on each change? Unless you have multiple concurrent users there's no point going back and forth to the database over and over again. You should generally just wait until all changes are complete and then save them all as a batch.
jmcilhinney at 2007-11-10 3:08:42 >