mrgonon
asked on
Why is datagridview not committing changes to the database in vb.net?
Using Visual studio 2005 Vb.net I automatically generated a bound datagridview
It used a data adapter to fill the data table. It also set the DataSource of a binding source to the data table and then bound the binding source to a datagridview. After you update in the datagridview, it
use the data adapter to save the changes to the database. The problem is although i see the changes in the application it never appears in the databse. The save is the following:
Me.validate()
Me.WorkspaceBindingSource. EndEdit()
Me.WorkspacetableAdaptor.U pdate(Me.d riverdatas et.Workspa ce)
No errors are raised on the save. Thanks in advance for your time!!
It used a data adapter to fill the data table. It also set the DataSource of a binding source to the data table and then bound the binding source to a datagridview. After you update in the datagridview, it
use the data adapter to save the changes to the database. The problem is although i see the changes in the application it never appears in the databse. The save is the following:
Me.validate()
Me.WorkspaceBindingSource.
Me.WorkspacetableAdaptor.U
No errors are raised on the save. Thanks in advance for your time!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.