Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Windows Forms
  4. Error:Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

Error:Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

Scheduled Pinned Locked Moved Windows Forms
csharphelpquestionannouncement
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    somagunasekaran
    wrote on last edited by
    #1

    Hi Iam using C#.Net 2.0 backend is MS Access.... When I want to update a record folowing exception has been appeared: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records Can anyone help me about the cause of the exception? regards Somasundaram

    U 1 Reply Last reply
    0
    • S somagunasekaran

      Hi Iam using C#.Net 2.0 backend is MS Access.... When I want to update a record folowing exception has been appeared: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records Can anyone help me about the cause of the exception? regards Somasundaram

      U Offline
      U Offline
      Urs Enzler
      wrote on last edited by
      #2

      To test concurrency the database access test whether any changes have happened since you loaded the data. Have a look at the original data (assuming you are using DataSets) and the data in the database. They differ and therefore the db access can not find the record it should update.

      -^-^-^-^-^- no risk no funk ................... please vote ------>

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups