Hi Folks,

Can anybody tell me how to test for a primary key constraint exception?

I'm running a stored procedure, using sqlclient.executenonquery, and then testing for an exception. However, if it is specifically a primary key violation, I need to record this fact. In the olden days, it was a simple matter of checking the error number - what does one do now?

Hi

I used this code to check for a unique constraint voliation, whether it is best practices I'm not sure, I couldn't find another way at the time.

 Catch ex As SqlException
            'catch any errors
            If ex.Number = 2627 Then 'catch error unique index contraint violated
                MessageBox.Show(ex.message,Application.ProductName , MessageBoxButtons.OK, MessageBoxIcon.Error)
            Else
                MessageBox.Show(ex.message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error)
            End If



Duncan

thats what I was thinking of, but it says "number is not a member of system.exception"

Hi

It would be sqlException and not exception

Duncan

given that the code i've got is

Try
    CmdInsert.ExecuteNonQuery()
Catch ex As Exception

how do I test sqlexception?

Hi

the exception handles all exceptions thrown, you an change the type of exception by removing the word exception as you do intellisense will then prompt you, for more information on exceptions look up exceptions in the help and msdn also on the debug menu there is an exceptions control, this basicly tell VS.net what to do when it comes across an exception, best not to change these settings until you are familar with exceptions.



Duncan