Solved

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records - TableAdapter.Update

Posted on 2008-10-02
2
1,095 Views
Last Modified: 2012-05-05
I get the following error message when I execute the below lines.  Any suggestions on what is wrong or how to troubleshoot this.

Me.QuoteReqBindingSource.EndEdit()
Me.QuoteReqTableAdapter.Update(Me.DsetQuote_Entry.QuoteReq)

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records
0
Comment
Question by:jaydwest
[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
2 Comments
 
LVL 22

Expert Comment

by:RedKelvin
ID: 22631166
Hi,
2 common reasons are
1. Editing an Auto Increment column.
2. Updating a row of a table which does not have a primary key.

RedK
0
 

Accepted Solution

by:
jaydwest earned 0 total points
ID: 22633349
Thanks for your help.  I did find the issue.  I was closing a connection object in the FInally block but declaring it in the Try Block.  The connection needed to be declared before the Try Statement.  
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 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