ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. The using statement forces the connection to close, regardless of whether there is an error
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();
}