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

Aamir Khan

15y2.1k.NET

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

2 Replies

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

Satish Bhat15y ago
Accepted 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, connection 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
0
Prabhu Raja15y ago
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
}
0