SQL connection within Catch block

Question

Hi all Can we make a SQL connection within catch block of a c# code? If so what is the procedure to do it. Because when i tried i am getting error saying The operation is not valid for the state of the transaction.

Vincent Maverick Durano · Answer

As the word itself suggest. The catch block is used for catching errors. Regarding your issue If you are using TransactionScope block then make sure that you are not using/openning the same connection to your database. Read this short discussion: http://stackoverflow.com/questions/193154/the-operation-is-not-valid-for-the-state-of-the-transaction-error-and-transact

Nanhe Siddique · Answer

as per my knowledge we can not write connection code inside catch block. When an exception is thrown the common language runtime (CLR) looks for the catch statement that handles this exception. If the currently executing method does not contain such a catch block the CLR looks at the method that called the current method and so on up the call stack. If no catch block is found then the CLR displays an unhandled exception message to the user and stops execution of the program. so general structure of try catch block try { // write here connection code } catch (Exception e) { Console.WriteLine( {0} Exception caught.  e); }