OleDb Exception Handling

Darren Murray

Hello. I am new to C# and have a question regarding catching specific exceptions. Below is my code and I would like to know if there is a better way. I would like the catch the specific OldeDbException for "invalid passsword" but how can I do this? What would I place in the Catch() statement? I used an if/then statement to catch it but is there another way in the catch block to specify an exact exception (invalid password)?

tx
try
{ dbConn.Open();}
catch (OleDbException e)
{
if (e.ErrorCode == -2147217843)
{Console.WriteLine("Invalid Password Entered"); }
else
{ Console.WriteLine(e.Message);}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User15y ago
Accepted answer
This looks correct to me. An invalid password apparently throws a OleDbException, so there is no separate "invalid password" exception.

I would recommend adding another catch block at the end to catch and process any other exception that might occur:

try
{ dbConn.Open();}
catch (OleDbException e)
{
if (e.ErrorCode == -2147217843)
{Console.WriteLine("Invalid Password Entered"); }
else
{ Console.WriteLine(e.Message);}
}
catch (Exception exc)
{
// process all of the other exception types
}
Darren Murray15y ago
Interesting about VB and exception handling...

thanks John P...I am glad I was on the right track. I will add an additional "catch all" block...
Vulpes15y ago
Just as a matter of interest, filtering exceptions is one of the few things that VB.NET can do which C# cannot do.

For example, the following works as expected:

Imports System

Class MyException : Inherits Exception

Public ErrorCode As Integer

End Class

Module Test

Sub Main

Try

Dim ex As New MyException
ex.ErrorCode = -2147217843
Throw Ex

Catch e As MyException When e.ErrorCode = 1

Console.WriteLine("Caught in the wrong place!")

Catch e As MyException When e.ErrorCode = -2147217843

Console.WriteLine("Caught in the right place!")

End Try

End Sub

End Module

There is no equivalent of the When clause in C# and so you have to catch all exceptions of a certain type and then check whether it's one you want within the catch clause itself.