[SOLUTION] C# code example where an email is sent to multiple recipients where the email address of the recipients comes from a stored proc

C# code example where an email is sent to multiple recipients where the email address of the recipients comes from a stored proc

I have an applicaion where the an email is sent out to multiple recipients of a course when somthing about that course has changed. I have a stored proc that gets the email address based off of the course id. I then send the email out reflecting the changes made to the course in an html formatted email. The issue that I am running into is trying to get the email to go out to the multiple recipients instead of the last attended's email address found from the stored proc.
My code is listed below:

//Send email of course cancellation
                        StoredProcConnect sprocRoster = new StoredProcConnect("sp_GetRosterByCourseID");
                        sprocRoster.AddParameters("COURSEID");
                        sprocRoster.AddValues(id);
                        DataSet ds = sprocRoster.Select();
                        if (ds == null)
                            Response.Redirect("ErrorMsg.aspx?error=Problem Getting Roster Info.  Tech team has been notified, please try again");

                                MailAddressCollection coll = new MailAddressCollection();                     
   if (ds.Tables[0].Rows.Count > 0)
                        {
                               string To = string.Empty;
                            foreach (DataRow row in ds.Tables[0].Rows)
                            {
                                msg.To.Add(row["email"].ToString() + "@COMPANY.com");
                                To = (row["email"].ToString() + "@COMPANY.com");
                            }

                            //toAddress = new Array(To);

                            coll.Add(To);

                            msg.From = new MailAddress("ClassChange@allstate.com");
                            msg.Subject = "An update to " + courseName + " has been made!";

                            // SendEmail();
                            if (chkCourseName.Checked == true)
                            {
                              var Body = this.PopulateBody(courseName,
                              courseName + "  Has been changed!",
                              "A new entry will be sent to your Outlook Calendar."
                              + "Please remove the old entry and accept the new entry." + name, "Sorry for any inconvenience that this change may have occured. " + "<br/>" + lblPresenter + "<br/>");
                              this.SendHtmlFormattedEmail(To, "An update to " + courseName + " has been made!", Body);
                            }
                         }

private string PopulateBody(string courseName, string title, string url, string description)
        {
            string body = string.Empty;
            using (StreamReader reader = new StreamReader(Server.MapPath("~/HtmlPage1.html")))
            {
                body = reader.ReadToEnd();
            }
            body = body.Replace("{UserName}", courseName);
            body = body.Replace("{Title}", title);
            body = body.Replace("{Url}", url);
            body = body.Replace("{Description}", description);
            return body;
        }

        private void SendHtmlFormattedEmail(string recepientEmail, string subject, string Body)
        {
            using (MailMessage mailMessage = new MailMessage())
            {
                mailMessage.From = new MailAddress("Responses@COMPANY.com");
                mailMessage.Subject = subject;
                mailMessage.Body = Body;
                mailMessage.IsBodyHtml = true;
                mailMessage.To.Add(new MailAddress(recepientEmail));
                Smtp info goes here
            }
        }

Open in new window

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 87

David Johnson, CD, MVPOwnerCommented: 2014-11-12

do you want to send 1 email with BCC or a bunch of individual emails?

get your collection from the stored procedure into an array
one email for each returned address
for (int counter=0; counter < array.count; counter++)
{
email.address = array[counter]
// rest of email
// email send routine
}
BCC
for (int counter=0; counter < array.count; counter++) { bcc.address = bccaddress + "," +array[counter] }
// rest of email
// email send routine

LVL 6

Mandeep SinghDatabase AdministratorCommented: 2014-11-12

Hi,

Try these:

http://hightechnology.in/how-to-send-multiple-emails-from-database-in-asp-net-using-c/
http://hightechnology.in/send-mail-from-database-in-batch-of-5-in-asp-net/

LVL 5

ashokpumcaCommented: 2014-11-24

Hi,
Try the code below

SqlDataAdapter adpSamp = new SqlDataAdapter("Your Stored Procduere", con);
adpSamp.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet dsSamp = new DataSet();
adpSamp.Fill(dsSamp);
if (dsSamp.Tables[0].Rows.Count > 0)
{
MailMessage mail = new MailMessage();

for (int j = 0; j < dsSamp.Tables[0].Rows.Count; j++)
{

String email = (dsIssue.Tables[0].Rows[j]["emailid"]).ToString();

mail.To.Add(email);
mail.Subject = "Mail Subject";
mail.From = new MailAddress("Email ID of sender");

mail.IsBodyHtml = true;
mail.Priority = MailPriority.High;
mail.Body = Your HTML Mail Format

SmtpClient smtp = new SmtpClient("YOUR SMTP CLIENT");
try
{
smtp.Send(mail);
}
catch (Exception ex)
{
LblMesg.Text = ex.Message.ToString();
}
}
}

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

newjeep19Author Commented: 2015-01-13

worked

C# code example where an email is sent to multiple recipients where the email address of the recipients comes from a stored proc

Who is Participating?

Already a member? Login.