Data Binding

[dalchri]

Does anyone know of any data binding objects other than the Microsoft Data Binding collection, the ADO data control, or the Data control that comes with VB?

My problem thus far is that the data source for all of these technologies is only updated whenever the user moves off the current record or one of the form controls loses focus.

If the user requests an on demand save from the form menu or exits the application, none of these things will occur and the data source does not get updated with the changes. Also, these data binding methods do not provide a way to explicitly move the data from the form controls to the data source.

Now, I could write code to move the data from each form control to the data source but that defeats the whole purpose of data binding.

Thanks for any suggestions!

 

[tedsmith]

Worse still you have to change rows in a datagrid but that could be good in a big network otherwise there would be network activity every time you touched a key.
You can put code to update the data in the Sub form_unload to stop it getting lost on exiting
I use a timer to update all the database say every 5 seconds after any input text box gets the focus until all similar command boxes have been lost focused (have them all the same name with a different index) I make them all go yellow in the same sub so the user can easily see which box has the focus