OleDb Exception Handling

Question

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);}
}

John Penn · 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 Murray · Answer

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...

Vulpes · Answer

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.