The basic difference between Close() and Dispose() is, when a Close() method is called, connection will be temporarily closed and can be opened once again. Where as Dispose() method permanently close and 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();   // here connection is open
// some code here which will be execute
     // code  will be execute when  error occurred in try block
 sqlcon.Close();                // close the connection
sqlcon.Dispose();         // desroy the  connection object
  Modified On Sep-18-2014 01:23:53 PM

Leave Comment