Trapping a particular SQL Error Code

[Guest]

HI there,

I am using a Try catch statement and I can return the Exception.Message
fine..but i want to catch a particular SQL error 1205 (locking). How do I say
:

catch (System.Exception ex)
{
//the below line is my interpretation of what I want to say!!
if (ex.SQLERRORCODE == 1205) {
do something else aswell as display label
}
lblError.Text="SQL Error [" + ex.Message + "]";
}
Or is it that .NET can't trap the code itself and I have to obtain this
through a return parameter of the SP??

Thanks,

 

[Patrice]

Use SqlException instead. This one should provide detailed information
about the error (Number property or Errors collection).

 

[Siva M]

Hello,

As Patrice said, catch SqlException specifically and check its Number
property.

HTH

message HI there,

I am using a Try catch statement and I can return the Exception.Message
fine..but i want to catch a particular SQL error 1205 (locking). How do I
say
:

catch (System.Exception ex)
{
//the below line is my interpretation of what I want to say!!
if (ex.SQLERRORCODE == 1205) {
do something else aswell as display label
}
lblError.Text="SQL Error [" + ex.Message + "]";
}
Or is it that .NET can't trap the code itself and I have to obtain this
through a return parameter of the SP??

Thanks,

 

[Guest]

*embarrased*

thanks!

Use SqlException instead. This one should provide detailed information
about the error (Number property or Errors collection).

--
Patrice

HI there,

I am using a Try catch statement and I can return the Exception.Message
fine..but i want to catch a particular SQL error 1205 (locking). How do I say
:

catch (System.Exception ex)
{
//the below line is my interpretation of what I want to say!!
if (ex.SQLERRORCODE == 1205) {
do something else aswell as display label
}
lblError.Text="SQL Error [" + ex.Message + "]";
}
Or is it that .NET can't trap the code itself and I have to obtain this
through a return parameter of the SP??

Thanks,

 

[Guest]

Thank you! Feeling very silly.