Primary Key Is Defined, Need To Process Thrown Error:

Hello:





I have a database table where a primary key is defined. When I enter data that is the same as another table, it does not allow and throws an error which I do want. What happens is that a Server Error in Application error type is thrown with the following message:





Violation of PRIMARY KEY constraint 'PK_cs_sc'. Cannot insert duplicate key in object 'cs_sc'. The statement has been terminated.





How can I detect the error in my own asp.net page code so that it does not forward my users to the asp.net server error page? Heres my code below... how can I check for success or failure within this code?





Dim conSqlConnect As SqlConnection


Dim strInsert As String


Dim cmdInsert As Sqlcommand


conSqlConnect = New SqlConnection( "Server=localhost;uid=var;pwd=var;database=var" )


strInsert = "Insert cs_sc ( [name] ) Values ( @name )"


cmdInsert = New SqlCommand ( strInsert, conSqlConnect )


conSqlConnect.Open()


cmdInsert.ExecuteNonQuery()


conSqlConnect.Close()