Arithmetic overflow exception

[ultraman]

Hi everyone !

 

I'm trying to catch a particular type of exception here, so basically I have a multiple catch block that catches OverflowException or else, any other exceptions.

 

Try
   cmd.ExecuteNonQuery()
Catch ofEx As OverflowException
   lblError.Text = "Overflow"
   lblError.Visible = True
Catch ex As SqlException
   lblError.Text =  "Any exception"
   lblError.Visible = True
End Try

 

 

The only problem is : it doesn't catch the overflow exception as it's supposed to, but rather sees it as a SqlException. Anyone knows what's wrong ?

[Derek Stone]

All errors generated by SQL Server will result in SqlException being thrown. You can query the SqlException.Errors collection and the SqlException.Number property for more details as to what caused the exception.