DBConcurrencyException not working!!

Question

Hello I am updating a SQL Server table with a stored procedure from my C# code. I am checking for concurrency by using a row id and row timestamp in my where clause of the stored procedure. I know things are working because if the row is modified in the SQL table after my DataSet is filled the update fails. I cannot catch a DBConcurrencyException in my code however!! the basics are try { daPeriods.Update(dsAccountsdtPeriods) } catch (DBConcurrencyException exDBC) { HandleDBCex(exDBC); } finally { Global.cnn.Close(); } Even thought the daPeriods.Update fails I go directly to finally If anyone can help me with this I will provide more details THANK YOU!! jmatt

jonathan 0 · Answer

Oh boy have I learned a bit from this one. It turned out that I had ContinueUpdateOnError set to true for the DataAdapter so an exception was not thrown. Things are good now. Thank you for your help! jmatt

Adam Erstelle · Answer

The finally block will execute if the try is successful or not. I'm not sure what the HandleDBCx() is doing perhaps you could take it out so that you can see the exception in a message box for debugging.