Solved

Why is datagridview not committing changes to the database in vb.net?

Posted on 2008-10-23
1
388 Views
Last Modified: 2013-11-26
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
Comment
Question by:mrgonon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
mrgonon earned 0 total points
ID: 22791859
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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question