Using tableadapter to update

[vbmom]

#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?

[wild_bill]

1. There is a rowstate property for each datarow. The update method checks these states an "updates" the database based on them. This includes inserts and deletes (update maybe a confusing name for this method). That also assumes you've setup your adapter's insert and delete commands. It sounds like you're after a single row update, so the best solution maybe a command object and the ExecuteNonQuery method.

2. As far as I know the adapter does not nativly support locking a record.

3. Hard to help you out without a code sample, and a better description of the problem.

[vbmom]

Thanks Bill...Re: your answer to #1...Do you mean to use Command object to do the initial query to fill the datagridview? If so, is it easy to unbind the datagridview (or don't I have to do this?) and fill it using a command object query?

I was thinking that, but don't know how to begin without starting over. help

[jmcilhinney]

The answer to question 3 is so ridiculously easy you will kick yourself. You don't have to do anything to get the grid to update, which is the whole point od data-binding. You simply have to update the DataRow and the grid will do the rest for you.

http://www.vbforums.com/showthread.php?t=469518

[vbmom]

jmc--You once pointed someone once to a sample on how to do master/detail with a bound datagridview and I tried it but got stuck on when adding a new row with the bindingnavigator's "add" button--if the user canceled, a the row would still be added. Here was my original post:

http://www.vbforums.com/showthread.php?t=483581

But no one answered and I gave up and instead passed the row data to the form, passed it back, updated the grid on edit or inserted on add--only if the user didn't cancel.

I may try what you say again, now that I'm not using the bindingnavigator's add and delete buttons, but using my own.

I'm sorry, I'm really don't have the big picture, as you can tell. If you can add anything to this, I would appreciate it, you really know your stuff.

[jmcilhinney]

There's no need to not use a BindingNavigator just because of that. The BindingNavigator has default behaviour but that can easily be changed. For instance, the Add button is assigned by default to the AddNew property, so pressing that button executes the default action for adding a new record. If you don't want that then you simply clear the addNew property and handle the Click event of the Add button yourself, allowing you to do whatever you want.

This is the sort of thing that illustrates why it's important to read the documentation for the classes you're using. If you don't know what they can do then how can you possibly know you're using them properly? I know most of what I know because I take the time to read.

[vbmom]

You're right about reading the doc. I didn't think until just now to hit F1 on the contol--and you actually get useful help. Before I was scouring the index and could not find properties and methods for controls. Silly me.