Concurrency violation SqlTableDataAdapter Insert RRS feed

  • Question

  • Hi,


    Can someone please shed some light on how I would go about resolving a concurrency violation that happens when I use the Update method of my SqlTableDataAdapter.  This error doesn't appear consistently and happens about once or twice a day.  This is a multiuser application using SQL 2005 Server and ado.net's SqlDataTableAdapter.Update method, this happens with new record additions.  My understanding is that Update uses the insert method with new record additons.


    The new record being added contains an identy field that I am autonumbering before hand using the dataset column properties autoincrement=yes, step = -1


    Any help would be appreciated, I thought concurrency violations when adding record was not possible..



    Thursday, November 15, 2007 10:00 PM