We help IT Professionals succeed at work.

how to remove error in database

Last Modified: 2017-04-24
when I want to save in my database I have error,how to fix that,I am working in Visual Basic.I can save only one information,when I try to save another then I get the error note
Watch Question


What I see is: Button35 uses BindingSource5  and  Button29 uses BindingSource4.
What exactly are you updating in _MyDatabase_4DataSet4  and  in _MyDatabase_4DataSet5?
If you are updating same tables then it can complain about the concurrency because one data set can contain obsolete data which were updated in the database by the previous/another UpdateAll call.

OR are you talking about the first UpdateAll success and the second UpdateAll for the same data set (same button) fails? Then you have to look into the database after the first save and confirm everything was saved correctly and then solve possible saving problems.


I have 6 pages and they all have the same datatable(I have template named solina1).When I use last 2 pages and insert data and click save they (sepperatly using) save in datatable,but when I put another data and try to save (same button) I have error.
First 4 pages dont work at all when try saving,they save only when I press button add new.
I put the code for all pages the same but something is wrong.


here are codes for first and last page

The code for all pages isn't the same because you are using different data sets. You can do it this way when these data sets are working on different data tables (on SQL backend). Once you have two data sets connected to the same data then the concurrency problem appears because data updated in one data set are not copied to other data sets and the application logic refuses saving because it evaluates it as data changed by other users.

You should redesign it. All your pages should use just ONE global dataset so they are all displaying the data from one source. Also, if you are displaying some information on more pages then you should always refresh this info when switching between pages.


I am a beekeeper and I make this form for keeping information of bees.
6 pages is for different places where we keep bees,but they have same datatables because we need to save same informations (same questions) for all places but each page sould save information for itself.
Unlock this solution and get a sample of our free trial.
(No credit card required)

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.