Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

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.Update(Me.driverdataset.Workspace)

No errors are raised on the save.  Thanks in advance for your time!!
0
mrgonon
Asked:
mrgonon
1 Solution
 
mrgononAuthor Commented:
The problem had to due with the copy to output directory setting. The DBwas getting updated, however, when I started the application it would always overwrite the DbB because it was set to copy always. Thus it apppeared things were not working. I cahnged it to copy if newere and problem solved.
I cant beleive that stumped me for 5 hours. :(
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now