ADO.Net

Question

How can I force the connection object to close after my datareader is closed??

Jignesh Trivedi · Answer

hi using(var myConnection = new SqlConnection(connectionstring)) { myConnection.Open(); //your code here myConnection.Close(); } using is dispose your connection object after connetion close. hope this help.

Krishna Garad · Answer

Try like this try { SqlConnection cn=new SqlConnection(...); cn.Open(); //work here } catch(Exception e) {} finally { cn.Close(); } in finally block any how connection got close if it is open.