try catch finally

Posted by gligom on Stack Overflow See other posts from Stack Overflow or by gligom
Published on 2012-12-16T17:02:05Z Indexed on 2012/12/16 17:02 UTC
Read the original article Hit count: 281

Filed under:

try-catch

|

finally

Maby this is simple for you, but for me is not. I have this code:

Private int InsertData()
{ 
  int rezultat = 0;
       try
       {
           if (sqlconn.State != ConnectionState.Open)
           {
               sqlconn.Open();
           }
           rezultat = (int)cmd.ExecuteScalar();

       }
       catch (Exception ex)
       {
           lblMesaje.Text = "Eroare: " + ex.Message.ToString();

       }
       finally
       {
           if (sqlconn.State != ConnectionState.Closed)
           {
               sqlconn.Close();
           }
       }

       return rezultat;
}

Is just for inserting a new record in a table. Even if this throw an error "Specified cast is not valid." "rezultat=(int)cmd.ExecuteScalar();" - the code is executed and the row is inserted in the database, and the execution continues.

Why it continues? Maby i don't understand the try catch finally yet Smile | :)

Thank you!

© Stack Overflow or respective owner

Related posts about try-catch

Java: error handling with try-catch, empty-try-catch, dummy-return

as seen on Stack Overflow - Search for 'Stack Overflow'
A searh uses recursively defined function that easily throws exceptions. I have tried 3 ways to handle exeptions: to ignore with an empty-try-catch() add-dummy-return stop err-propagation due to exeption throw a specific except. (this part I don't really understand. If I throw except, can I force… >>> More
Try-Catch-Throw in the same Java class

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to catch a method in the current class the try-catch block is running on? for example: public static void arrayOutOfBoundsException(){ System.out.println("Array out of bounds"); } ..... public static void doingSomething(){ try { if(something[i] >=… >>> More
[Blog] N'utilisez jamais try {} catch {}

as seen on Dot Net Guru - Search for 'Dot Net Guru'
C'est en somme le conseil donn? par Karl Seguin sur son blog. Pour lui, l'utilisation du try/catch pour g?rer une exception est une mauvaise pratique : "If an exception happens, you need to know about it. If a truly unexpected exception happens, you're better off (most of the time) crashing than… >>> More
Visual Studio ignore try catch - debug only

as seen on Stack Overflow - Search for 'Stack Overflow'
I think error handling is a good idea. :) When debugging it can get in the way - especially with nice user friendly messages. In VB6 I could just check a box for the compiler to ignore my error handling. I found the dialog that allows me to do something similar in VS, but it's about 10,000 check… >>> More
How and where do we write try catch block to handle Exception

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using C# language to develope a Windows application. Our windows application consists of three layers (UI,Business and DataAccess layer). In Business Layer there are some public (business) methods through which UI communicates wilh Business layer classes. These public methods also have some… >>> More

Related posts about finally

finally in exception handling

as seen on Stack Overflow - Search for 'Stack Overflow'
What exactly does a finally block in exception handling perform? >>> More
Exception from within a finally block

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider the following code where LockDevice() could possibly fail and throw an exception on ist own. What happens in C# if an exception is raised from within a finally block? UnlockDevice(); try { DoSomethingWithDevice(); } finally { LockDevice(); // can fail with an exception } >>> More
PL/SQL Practices - "On Emulating FINALLY"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Code PL/SQL to function like the Java FINALLY section. >>> More
Unreachable statement when using return in finally?

as seen on Stack Overflow - Search for 'Stack Overflow'
this compiles class ex1 { public int show() { try { int a=10/10; return 10; } catch(ArithmeticException e) { System.out.println(e); } finally { System.out.println("Finally"); … >>> More
Subterranean IL: Compiling C# exception handlers

as seen on Simple Talk - Search for 'Simple Talk'
An exception handler in C# combines the IL catch and finally exception handling clauses into a single try statement: try { Console.WriteLine("Try block") // ... } catch (IOException) { Console.WriteLine("IOException catch") // ... } catch (Exception e) { Console.WriteLine("Exception… >>> More