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

• • Reply

  7 years ago

  by Ryanjuve

  Ryan Mifsud

  , Malta

  Joined 13 years ago

  Hi All,

  I'm developing a blog using ASP.NET. I am connecting to the database using datasets. My problem is when I try to do update a particular row in the database.

  This is the Method that is giving me the concurrency error.

  internal void UpdateChanges(BlogDataSet.BlogDataTable data)
          {                     
              BlogTableAdapter blogTableAdapter = new BlogTableAdapter();
              blogTableAdapter.Update(data);
          }
  

  The Blog is only being used by me so there are no other users changing the data. I am using the same method to insert new data in the table and it works perfectly. Can anyone provide me some help since I've been trying this problem for hours but I didn't Manage.

  Thanks in Advanced Ryan

  Report abuse