exception handling using SQLClient - is this the only exception that is caught???

[James Cooke]

Hi all,

I want to catch a duplicate key exception. I do not want to provide that
verbose message from the MSSQL server - I would put a user friendly message
out, like

"The item you have added already exists in the database. Please change
the description and try to save again."

instead of
System.Data.Sql Client.SqlExcep tion: Cannot insert duplicate key row in
object 'Tree' with unique index 'KeySiteParentT reeNodename'.
The statement has been terminated.
at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
at ClaPub.DataAcce ss.ExecuteComma nd(String SQL, DataElements&
DataElements, BinaryDataEleme nts& BinaryDataEleme nts) in C:ClaPubClasses Data
Access ClassesDataAcce ss.vb:line 129

How do I do this? because the only error captured by .net is the general
System.Data.Sql Client.SqlExcep tion. I have tried using
System.Data.Dup licateNameExcep tion but that is not caught.

Try
SqlConnection.O pen()
m_ReturnValue = SqlCmdObj.Execu teNonQuery()
SqlConnection.C lose()
Catch e As System.Data.Sql Client.SqlExcep tion 'THIS IS CAUGHT
EVERY TIME
...
Catch e As System.Data.Dup licateNameExcep tion 'THIS IS NEVER
CAUGHT
...
Catch e As System.Data.NoN ullAllowedExcep tion 'THIS IS NEVER
CAUGHT
...
End Try

[Armin Zingler]

"James Cooke" <ja************ ********@yahoo. com> schrieb

I want to catch a duplicate key exception. I do not want to provide
that verbose message from the MSSQL server - I would put a user
friendly message out, like

"The item you have added already exists in the database. Please
change
the description and try to save again."

instead of
System.Data.Sql Client.SqlExcep tion: Cannot insert duplicate key
row in
object 'Tree' with unique index 'KeySiteParentT reeNodename'.
The statement has been terminated.
[...]

The Errors property of the SqlException object probably contains the
error(s). Maybe checking the Number property of an SQLError object helps.

BTW, there is a specialized group for ADO.Net questions:
microsoft.publi c.dotnet.framew ork.adonet
--
Armin

[William Ryan]

exc.Message will give you a cleaner name. You could also write your own
exception class with whatever message you like, then throw a YourException
from SQLException.

Incidentally, the second two will not get caught when you have SQLClient
exception at the top because everything that could come from ExecuteNonQuery
(just about) will be caught by the SqlException first. NoNullAllowed would
only happend if you tried to insert a null into a DataTable, not Database
talbe, where the column was marked allownull = false.

Your in different libraries, but remember, always go from specific to broad
exception catches b/c the broad ones, if they are first ,will catch
everything more precise.

HTH,

Bill
"James Cooke" <ja************ ********@yahoo. com> wrote in message
news:ev******** ******@TK2MSFTN GP09.phx.gbl...

Hi all,

I want to catch a duplicate key exception. I do not want to provide that
verbose message from the MSSQL server - I would put a user friendly message out, like

"The item you have added already exists in the database. Please change
the description and try to save again."

instead of
System.Data.Sql Client.SqlExcep tion: Cannot insert duplicate key row in
object 'Tree' with unique index 'KeySiteParentT reeNodename'.
The statement has been terminated.
at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
at ClaPub.DataAcce ss.ExecuteComma nd(String SQL, DataElements&
DataElements, BinaryDataEleme nts& BinaryDataEleme nts) in C:ClaPubClasses Data Access ClassesDataAcce ss.vb:line 129

How do I do this? because the only error captured by .net is the general
System.Data.Sql Client.SqlExcep tion. I have tried using
System.Data.Dup licateNameExcep tion but that is not caught.

Try
SqlConnection.O pen()
m_ReturnValue = SqlCmdObj.Execu teNonQuery()
SqlConnection.C lose()
Catch e As System.Data.Sql Client.SqlExcep tion 'THIS IS CAUGHT EVERY TIME
...
Catch e As System.Data.Dup licateNameExcep tion 'THIS IS NEVER
CAUGHT
...
Catch e As System.Data.NoN ullAllowedExcep tion 'THIS IS NEVER
CAUGHT
...
End Try