Concurrency violation: The DeleteCommand affected 0 of the expected 1 records.

Question

3.00/5 (2 votes)

See more:

I am working in Visual Basic with an Access Database. In my program, I add a new row to the database as follows:

VB

Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim NewRow As DataRow
NewRow = ds.Tables(QuizName).NewRow()
NewRow.Item("QuestionNumber") = Row + 2
ds.Tables(QuizName).Rows.Add(NewRow)
da.Update(ds, QuizName)

The table is updated successfully. However, if I immediately after delete the newly created record, an error occurs. Below is the code I use to delete the row from the table:

VB

Dim cb As New OleDb.OleDbCommandBuilder(da)
ds.Tables(QuizName).Rows(Row).Delete()
da.Update(ds, QuizName)

Where 'Row' is the location of the newly created row. However, the da.Update line has an error:

DBConcurrencyException was unhandled
Concurrency violation: the DeleteCommand affected 0 of the expected 1 records.

I have no real idea how to fix this problem. It seems that the dataset or the database does not contain the row I want to delete. I can confirm that the access database does contain the row (I open the database after making it, and the new row exists).

Any help remedying this issue would be greatly appreciated!

Posted 25-May-14 16:25pm

JOFA666

Add a Solution

2 solutions

Solution 1

You need to reload your DataTable after you do the Add so the record picks up any ID's the database assigned.

Posted 26-May-14 3:12am

Dave Kreskowiak

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JOFA666 · Accepted Answer · 2014-05-27T23:37:00

Thanks Dave. I tried that before, but I must have put it in the wrong spot because that essentially solves my problem! I also had to clear the DataSet before filling it again. The solution is in the last two lines of the code below:

VB

NewRow = ds.Tables(QuizName).NewRow()
NewRow.Item("QuestionNumber") = Row + 2
ds.Tables(QuizName).Rows.Add(NewRow)
da.Update(ds, QuizName)
ds.Clear()
da.Fill(ds, QuizName)