Which are the connection to be closed in Finally block of try-Catch

Question

Hi frnds i want to know which are the connection to be closed in finally block in asp.net web form..how it can be done..pls explain thanks @@mir

Satish Bhat · Answer

Closing the connection in the finally block is one of the recommended ways of doing it. Here is the sample code SqlConnection connection = new SqlConnection(connectionString); try { string queryString = YOUR ACTUAL QUERY using (SqlCommand command = new SqlCommand(queryString connection)) { command.Connection.Open(); // Open connection command.ExecuteNonQuery(); // Execute query } } catch (Exception e) { // Handle re-throw. Also you might want to catch more specific exceptions. } finally { if (connection != null) connection.Close(); // Close connection } You can also use 'using' statement around the code that uses the connection. using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = SELECT * FROM SomeTable; //Or any command like Insert/Update/Delete // Execute the query here... } // Connection automatically closed When the end of the using statement block is reached c onnection object gets disposed immediately. As a rule when you use an IDisposable object you should declare and instantiate it in a using statement. The using statement calls the Dispose method on the object in the correct way. It also causes the object itself to go out of scope as soon as Dispose is called

Prabhu Raja · Answer

You can Also Use finally Block to Close Your Commad Object. SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(Select getDate()); //Your Query try { } catch (Exception e) { // Handle re-throw. Also you might want to catch more specific exceptions. } finally { cmd.Parameter.Clear(); //In case If you have used SqlCommand Object With Parameters. cmd.Dispose(); //It will free all resources used by Command Object. connection.Close(); // Close connection }