SqlConnection myConnection = new SqlConnection(connectionString);
try
{
  myConnectionn.Open();
  //Code
}
finally
{
  sqlConnection.Close();
}

using(SqlConnection myConnection = new SqlConnection(connectionString))
{
  myConnection.Open();
  //Code
}