Use the using statement to properly dispose of resources

Do

using (SqlConnection connection = new SqlConnection("connection string"))
{
    connection.Open();
    // Do something with the connection
}

Don't

SqlConnection connection = new SqlConnection("connection string");
connection.Open();
// Do something with the connection
connection.Close();