C#

Helfdane wrote:

reminds himself not to start coding too early in the morning

Christian Graus wrote:

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

SqlConnection conn;
SqlTransaction trans;

try {
  conn = new SqlConnection(connectionString);
  conn.Open();
  SqlTransaction trans = conn.BeginTransaction();
}
catch (SomeTypeOfException ex) {
  // deal with exception
}
finally {
  // transaction as well??

  if (conn != null) {
    conn.Close();
    conn.Dispose();
  }
}

// if we've got a trasnaction carry on:
if (trans != null) {
  try {
    string query = "query goes here";
    SqlCommand command = new SqlCommand(query, conn, trans);
    // add parameters
    command.ExecuteNonQuery();
    trans.Commit();
  }
  catch (SomeOtherException ex) {
    // deal with exception
   trans.Rollback();
  }
  finally {
    if (conn != null) {
      conn.Close();
      conn.Dispose();
    }
  }
}