Sending emails from database in C#

Question

Hi im working on a software project with C# im stuck with this problem sending emails to specific emails works great now what i want is when i tick a checkbox emails from a table in database get in the add to Message etc...... this is my code: SmtpClient smtp = new SmtpClient(smtp.gmail.com 587); smtp.EnableSsl = true; smtp.Timeout = 10000; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.UseDefaultCredentials = false; smtp.Credentials = new System.Net.NetworkCredential(markfenech27@gmail.com mypassword); message.From = new MailAddress(markfenech27@gmail.com Mark Fenech); if (chcbox_members.Checked) { message.To.Add(// here im adding the db Code to Select Email from tblMember } else { message.To.Add(txt_emailTo.Text); } message.Subject = txt_Subject.Text; message.Body = label9.Text +   + label5.Text + 
+ label10.Text +   + label6.Text + 
 + label11.Text +   + label7.Text+ 
 + label12.Text +  + label8.Text; message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; smtp.Send(message); This is an image of te design so you can understand more : http://i55.tinypic.com/wbtncm.jpg

Jonathas Sucupira · Answer

Try this: Please note that now I am calling the sub rotine that sends the email from the ReadOrderData. Also you should put a try{} on your email function like I did on the one from yesterday. private void ReadOrderData() { string queryString = Your query here;; using (SqlConnection connection = new SqlConnection(Your Connection)) { SqlCommand command = new SqlCommand(queryString connection); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); // Call Read before accessing data. while (reader.Read()) { sendEmail(reader[0].ToString()); } // Call Close when done reading. reader.Close(); } catch (Exception ex) { Response.Write(This error occurred=  + ex.Message); } finally { connection.Close(); command = null; } } } private void sendEmail(string message) { SmtpClient smtp = new SmtpClient(smtp.gmail.com 587); smtp.EnableSsl = true; smtp.Timeout = 10000; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.UseDefaultCredentials = false; smtp.Credentials = new System.Net.NetworkCredential(markfenech27@gmail.com mypassword); message.From = new MailAddress(markfenech27@gmail.com Mark Fenech); if (chcbox_members.Checked) { message.To.Add(// here im adding the db Code to Select Email from tblMember } else { message.To.Add(message); } message.Subject = txt_Subject.Text; message.Body = label9.Text +   + label5.Text + 
+ label10.Text +   + label6.Text + 
 + label11.Text +   + label7.Text+ 
 + label12.Text +  + label8.Text; message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; smtp.Send(message); } }

Mark Fenech · Answer

tnx alot it worked great now :D ty goodluck for future

Jonathas Sucupira · Answer

Also to send email directly from the database you can use something like this http://www.eggheadcafe.com/tutorials/aspnet/04f92b99-2f84-4ca6-9a80-570d8f88d6b5/sending-mails-in-sql-server.aspx

Jonathas Sucupira · Answer

You should try to add a loop to try and read through your table.

Mark Fenech · Answer

sorry i tought it worked fine but only the first one in the list of my table the email is being sent to :/ any help pls maybe i need to do some syntax ?

Mark Fenech · Answer

tnx alot it worked :D

Jonathas Sucupira · Answer

I would do something like this. Probably not the easiest way. private string retriveQuestions() { string message = string.Empty; string strcon = Your Connectionstring; System.Data.SqlClient.SqlConnection Connection = new System.Data.SqlClient.SqlConnection(strcon); System.Data.SqlClient.SqlDataAdapter SQLstatement = new System.Data.SqlClient.SqlDataAdapter(Your query Connection); System.Data.DataSet info = new System.Data.DataSet(); try { SQLstatement.Fill(info); Connection.Open(); if (info.Tables[0].Rows.Count > 0) { SQLstatement.Fill(info); message = info.Tables[0].Rows[0][0].ToString(); } } catch (Exception ex) { Response.Write(ex.Message); } finally { Connection.Close(); Connection.Dispose(); Connection = null; } return message; } private void sendEmail() { SmtpClient smtp = new SmtpClient(smtp.gmail.com 587); smtp.EnableSsl = true; smtp.Timeout = 10000; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.UseDefaultCredentials = false; smtp.Credentials = new System.Net.NetworkCredential(markfenech27@gmail.com mypassword); message.From = new MailAddress(markfenech27@gmail.com Mark Fenech); if (chcbox_members.Checked) { message.To.Add(// here im adding the db Code to Select Email from tblMember } else { message.To.Add(retriveQuestions()); } message.Subject = txt_Subject.Text; message.Body = label9.Text +   + label5.Text + 
+ label10.Text +   + label6.Text + 
 + label11.Text +   + label7.Text+ 
 + label12.Text +  + label8.Text; message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; smtp.Send(message); }