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


VB.Net ADO.Net Dataset

Posted on 2010-01-11
Medium Priority
Last Modified: 2012-08-14
Good Day

I have a question that I cannot seem to locate an answer for.  Three people take out a dataset on the same table Categories which has 9 records.  They all locally add the 10th category to their dataset.  Person A syncs back up to the database and now there are 10 catergories.
Person B then tries to sync back to the database via the DataAdapter.  

Would an error result? Would the dataabse somehow handle it? Does the DBA have to have something in place to handle?

Question by:Jimbo99999
1 Comment
LVL 14

Accepted Solution

shahprabal earned 2000 total points
ID: 26285316
Here is the answer as well as ways to prevent this from happening :


Basically when the person B tries to update using the old dataset he/she will get a DBConcurrency Exception.

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Loops Section Overview

564 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