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,
"claire" <cl**********@hotmail.com> wrote in message
news:eP**************@TK2MSFTNGP09.phx.gbl...

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,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
Thank you for your time.

Claire

[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/
"claire" <cl**********@hotmail.com> wrote in message
news:eP**************@TK2MSFTNGP09.phx.gbl...

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