Exception Number in VS2005

[=?Utf-8?B?Umljaw==?=]

How to I get the Exception Number (code) for a database related error?
I get the following error and I need to catch it to display a custom message.

System.InvalidC astException: Unable to cast object of type 'System.DBNull'
to type 'System.Byte

[=?Utf-8?B?Umljaw==?=]

RE: Exception Number in VS2005

Never mind; i've figured it out as:

ex is System.InvalidC astException

"Rick" wrote:

How to I get the Exception Number (code) for a database related error?
I get the following error and I need to catch it to display a custom message.
>
System.InvalidC astException: Unable to cast object of type 'System.DBNull'
to type 'System.Byte

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

Re: Exception Number in VS2005

On Oct 3, 2:04 pm, Rick <R...@discussio ns.microsoft.co mwrote:

How to I get the Exception Number (code) for a database related error?
I get the following error and I need to catch it to display a custom message.
>
System.InvalidC astException: Unable to cast object of type 'System.DBNull'
to type 'System.Byte

Hi,

There is no such a thing, You can know the problem by the Exception
Type and the Message.
In your case it;s clearly a casting issue

Tip:
try to use coalesce in the sql query