types of sql exception

[claire]

Hi,

I have a windows form with a typed dataset. When i call an update on the
database i want to catch the exceptions. I was wondering what different
types of sql exceptions there are.

Also i was told that the order that you catch them is important. If so, what
sort of order is this?

Thank you for your time.

Claire

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Claire,

Hi,

I have a windows form with a typed dataset. When i call an update on the
database i want to catch the exceptions. I was wondering what different
types of sql exceptions there are.

SqlException?

I'm reading now that it is not generated on .NET 1.0 though.

Also i was told that the order that you catch them is important. If so, what
sort of order is this?

From the more especific to the more general, for example you put a catch
clause for SqlException and later one for Exception, it the exception is not
of type of SqlException or one of his derived classes it will jump to the
next catch clause , if the last clause is for Exception it will match all
the exceptions.



Cheers,

 

[William Ryan eMVP]

You can catch exceptions through SqlException class, which may have multiple
exceptions. To do this 'correctly' you'll need to loop through the
exceptions. For exceptions w/ severity < 10, you can trap the InfoMessage
event (which will also give you back the results of Print Statements for
instance). This should help
http://www.knowdotnet.com/articles/connections.html

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/