#1 When I use my xxxTableAdapter.Update method, does that write back only changes? It doesn't write back the entire dataset, does it?

#2 I intend to have multiple users accessing the same table, making record edits and updating. I want to do some kind of record locking when each user is editing a specific row. Can I do that using the tableadpater.update method somehow?

#3 I also am using a bindingnavigator with the datagridview. When a user edits a row, I pass the row values to another form, let them edit, and pass them back. I'm having trouble getting the datagridview to reflect the changes. I have some code that sort of works, but not always. Any suggestions?