使用SQL2008的数据库邮件

最新推荐文章于 2024-10-08 15:41:48 发布

yuandongy

最新推荐文章于 2024-10-08 15:41:48 发布

阅读量360

点赞数

分类专栏： SQL Mail C# vs2008 文章标签：数据库 sql string email html user

本文链接：https://blog.csdn.net/yuandongy/article/details/6952604

版权

vs2008 同时被 3 个专栏收录

4 篇文章 0 订阅

订阅专栏

SQL

2 篇文章 0 订阅

订阅专栏

2 篇文章 0 订阅

订阅专栏

试了很久的System.Net.Mail，能发没报错，就是收不到，原因找不到

        public void EMail(string mailto, string subject, string body)
        {
            MailMessage mail = new MailMessage();
            MailAddress mailfrom = new MailAddress("xx@163.com", "WebMaster");
            MailAddress mailto = new MailAddress(mailto, "WebUser");
            mail.From = mailfrom;
            mail.To.Add(mailto);
            mail.Subject = subject;
            mail.Body = body;
            mail.BodyEncoding = System.Text.Encoding.UTF8;
            mail.IsBodyHtml = true;

            SmtpClient client = new SmtpClient();
            client.Host = "smtp.163.com";
            client.EnableSsl = true;
            client.Port = 587;
            client.UseDefaultCredentials = true;
            client.Credentials = new System.Net.NetworkCredential("user", "password");
            client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
            client.Send(mail);
        }

算了放弃了这个办法，改用SQL2008的数据库邮件
建立

Alter proc Mail
(
@pto nvarchar(255),
@psubject nvarchar(255),
@pbody ntext
)
as
begin
Exec msdb.dbo.sp_send_dbmail @profile_name='WebMaster',
    @recipients=@pto,
    @subject=@psubject,
    @body=@pbody,
    @body_format = 'HTML'
end

好了