C#按数据库邮件列表发送邮件

永久禁言

1. using System;
   
2. using System.Net;
   
3. using System.Net.Mail;
   
4. using System.Text;
   
5. using System.Threading;
   
6. delegate void sendDelegate(string from, string to, string subject, string body, string host, int port, string userName, string password);
   
7. /// <summary>
   
8. /// 发送电子邮件
   
9. /// </summary>
   
10. /// <param name="from">发件人</param>
    
11. /// <param name="to">收件人</param>
    
12. /// <param name="subject">邮件主题</param>
    
13. /// <param name="body">邮件内容</param>
    
14. /// <param name="host">发送服务地址(smtp.qq.com)</param>
    
15. /// <param name="port">发送邮件服务器端口(25) int型</param>
    
16. /// <param name="userName">用户名</param>
    
17. /// <param name="password">密码</param>
    
18. public void sendmail(string from, string to, string subject, string body, string host, int port, string userName, string password)
    
19. {
    
20.     MailMessage message = new MailMessage(from, to, subject, body);
    
21.     message.IsBodyHtml = true;
    
22. 
    
23.     message.BodyEncoding = Text.Encoding.UTF8;
    
24.     message.Attachments.Add(new Attachment("c:\\log.log"));
    
25.     SmtpClient client = new SmtpClient(host, port);
    
26.     client.Credentials = new NetworkCredential(userName, password);
    
27.     client.DeliveryMethod = SmtpDeliveryMethod.Network;
    
28.     client.Send(message);
    
29. }
    
30. 
    
31. SqlConnection conn = new SqlConnection();
    
32. conn.ConnectionString = "Data Source=(local);Integrated Security=SSPI;Initial Catalog=db_showHouse"; 　　//打开连接
    
33. conn.Open();
    
34. SqlCommandcmd = new SqlCommand("select Email from Employee", conn);
    
35. SqlDataReader drNew = cmd.ExecuteReader();
    
36. if (drNew.HasRows)
    
37. {
    
38.         while (drNew.Read())
    
39.                 new sendDelegate(sendmail).BeginInvoke("someone@somecompany.com",drNew[0].ToString(),"subject","body","smtp.somescompany.com",25,"userName","password");
    
40. }
    
41. drNew.Close();

复制代码

bjxy87

加油 支持 强烈的