SQL connection within Catch block

Murugesh P

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

2 Replies

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

Vincent Maverick Durano11y ago
Accepted 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 Siddique11y ago
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);         }
```