How to automatically save records?

[Robert Dufour]

Vs2005, .Net 2.0, vb.Net, Winforms
I have a form with a binding source, a binding navigator, a table adapter
and a dataset (all using sql 2005 same table, to keep it simple)
When the user tries using next, previous, first or last, or closes the form
I would like to automatically detects if any changes were made and if so do
an update. If the update was unsuccessful, user should not be allowed to
navigate nor close the form until problem is resolved.

So questions :
in the binding navigator, how to detect if changes were made, how to prevent
navigation from completing?

Thanks for any help,
Bob

[Master Programmer]

Do it manually with SQL. Don't trust databinding as its only included
in vb to help novices learn.

Hope this helps.

Steve

On Aug 10, 10:58 pm, "Robert Dufour" <[e-mail]:

Vs2005, .Net 2.0, vb.Net, Winforms
I have a form with a binding source, a binding navigator, a table adapter
and a dataset (all using sql 2005 same table, to keep it simple)
When the user tries using next, previous, first or last, or closes the form
I would like to automatically detects if any changes were made and if so do
an update. If the update was unsuccessful, user should not be allowed to
navigate nor close the form until problem is resolved.

So questions :
in the binding navigator, how to detect if changes were made, how to prevent
navigation from completing?

Thanks for any help,
Bob