|
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();
}
|