Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how use the dispose method for close the connection
Ask Question
Rajesh Goswami
Rajesh Goswami

Other

Message

4 Answers

Shankar M
Shankar M 25 Feb 2013
Report Abuse
Post is removed by the User.
Shankar M
Shankar M 25 Feb 2013
Report Abuse
Hi Rajesh,

You don't need to explicitly close the connection that is opened, You can use the Using Clause.

using(SqlConnection sqlcon = new SqlConnection(constring))
  {
   }

The leverage of using it is the resources tied up to it are freed automatically with out explicitly calling the
Dispose() Method.

Thanks,
Shankar
Shankar M
Shankar M 25 Feb 2013
Report Abuse
Hi Rajesh,

You don't need to explicitly close the connection that is opened, You can use the Using Clause.

using(SqlConnection sqlcon = new SqlConnection(constring))
  {
   }

The leverage of using it is the resources tied up to it are freed automatically with out explicitly calling the
Dispose() Method.

Thanks,
Shankar
yash Singh
yash Singh 18 Dec 2010
Report Abuse

Dispose() method permanently removes connection object from memory and the resource no longer exists for any further          processing.


string constring = "Server=(local);Database=my; User Id=sa; Password=sa";
SqlConnection sqlcon = new SqlConnection(constring);
 sqlcon.Open();   // connection is open

try
{
//  code here which will be execute
}
catch
{
     // code  will be execute when  error occurred in try block
}
finally
{
 sqlcon.Dispose();         // close and desroy the  connection object
}

advertising