DBConcurrencyException not working!!

jonathan 0

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(dsAccounts,"dtPeriods") } 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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

jonathan 022y ago
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 Erstelle22y ago
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.