Sending emails from database in C#

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("[email protected]", "mypassword");


               message.From = new MailAddress("[email protected]", "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 + "\n"+ label10.Text + "   " + label6.Text + "\n" + label11.Text + "   " + label7.Text+ "\n" + label12.Text + "   "+ label8.Text;
               message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
               smtp.Send(message);
   }


}