private void SQLTransaction(MySqlConnection conn, MySqlCommand cmd, DBMailStruct mail) { using (MySqlTransaction trans = conn.BeginTransaction()) { try { cmd.Transaction = trans; cmd.ExecuteNonQuery(); trans.Commit(); mail.isSolve = true; if (mail.sendTo != null) { mail.sendTo(mail); } } catch (Exception e) { trans.Rollback(); if (mail.sendTo != null) { mail.isSolve = false; mail.sendTo(mail); } throw e; } } }
private void SQLAdapter(MySqlCommand cmd, DBMailStruct mail) { using (MySqlDataAdapter adapter = new MySqlDataAdapter(cmd)) { DataTable dataTable = new DataTable(); adapter.Fill(dataTable); mail.dataTable = dataTable; mail.isSolve = true; if (mail.sendTo != null) { mail.sendTo(mail); } } }