We help IT Professionals succeed at work.

how to remove error in database

163 Views
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
screen-22.56.45-09.04.2017-.png
screen-23.01.32-09.04.2017-.png
WP_20170411_001.jpg
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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.

Author

Commented:
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.
screen-datatables.png
screen-datasource.png

Author

Commented:
here are codes for first and last page
screen-first-page-code.png
screen-last-page-code.png
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
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.
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

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.

OR

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.