Checking for a particular type of SQLException

ToxicCloud

New member
Joined
Dec 5, 2007
Messages
2
Programming Experience
3-5
Hi, We are experiencing the occasional timeout issue when a stored procedure runs. I am already trapping for SqlException exceptions and displaying a message accordingly. I would like to further refine this by displaying a particular message when a timeout occurs. When i trap for SqlExceptions is there a way to then test if the SQLException in question is a timeout exception. At the moment i am just checking the SQLException .message property and if is the timeout message i know it was a timeout. Is there a better way to do this?

TIA
 
Back
Top