ASP.NET Tutorial/ADO.net Database/using

The using statement forces the connection to close, regardless of whether there is an error

   <source lang="csharp">

using statement also disposes of the Connection object. If you need to reuse the Connection, then you need to reinitialize it.

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True;Initial Catalog=Pubs"); SqlCommand cmd = new SqlCommand("INSERT Titles (Title) VALUES ("Some Title")", con); using (con) {

 con.Open();
 cmd.ExecuteNonQuery();

}</source>

use a try...catch statement to force a connection to close

   <source lang="csharp">

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True;Initial Catalog=Pubs"); SqlCommand cmd = new SqlCommand("INSERT Titles (Title) VALUES ("Some Title")", con); try {

 con.Open();
 cmd.ExecuteNonQuery();

} finally {

 con.Close();

}</source>