public static void NewMember() { SqlCommand command = null; DataSet ds = null; SqlDataAdapter dataAdapter = null; try { SqlTriggerContext triggContext = SqlContext.TriggerContext; switch (triggContext.TriggerAction) { case TriggerAction.Insert: // Retrieve the connection that the trigger is using using (SqlConnection connection = new SqlConnection(@"context connection=true")) { connection.Open(); command = new SqlCommand(@"SELECT * FROM INSERTED;", connection); dataAdapter = new SqlDataAdapter(command); ds = new DataSet(); dataAdapter.Fill(ds); DataTable table = ds.Tables[0]; DataRow row = table.Rows[0]; DataColumnCollection columns = table.Columns; string TargetEmailAddress = (string)row["Email"]; string subject = Templates.NewMemberSubject; string body = Templates.NewMemberBody; subject = MergeHelper.GenericMerge(subject, columns, row); body = MergeHelper.GenericMerge(body, columns, row); MailHelper.SendEmail(TargetEmailAddress, subject, body); } break; } } catch { } finally { try { if (command != null) { command.Dispose(); } if (ds != null) { ds.Dispose(); } if (dataAdapter != null) { dataAdapter.Dispose(); } } catch { } } }