c# 調用sqlserver sp_send_dbmail 預存程序 發送郵件

標籤：

 <appSettings>
      <add key="MailProfile" value="AAA"/> </appSettings>

private void btnSendMail()
        {
            try
            {
                string mailProfile = ConfigurationManager.AppSettings["MailProfile"];

                string receivers = "[email protected]";
                string cc = "";
                string connectionString = ConfigurationManager.ConnectionStrings["BB"].ConnectionString;
                string subject = "subject";
                string fileAttachments = string.Empty;
                string body = string.Empty;

 　　　　// \r表示斷行符號，\n 換行 一般都是\r\n 合用
                body = "Hi Gugs:\r\n\r\n ";
                body = body + "\r\n\r\n Source:" + comSource.Text;
                body = body + "\r\n\r\n Thanks";

　　　　　　//初始化預存程序的參數

                var paramMailProfile = new SqlParameter("@profile_name", SqlDbType.NVarChar, 128) { Value = mailProfile };
                var paramReceivers = new SqlParameter("@recipients", SqlDbType.NVarChar, -1) { Value = receivers };
                var paramCC = new SqlParameter("@copy_recipients ", SqlDbType.NVarChar, 255) { Value = cc };
                var paramBody = new SqlParameter("@body", SqlDbType.NVarChar, -1) { Value = body };
                var paramSubject = new SqlParameter("@subject", SqlDbType.NVarChar, 255) { Value = subject };
                var paramFileAttachments = new SqlParameter("@file_attachments", SqlDbType.NVarChar, -1) { Value = fileAttachments };

                using (var conn = new SqlConnection(connectionString))
                using (var cmd = new SqlCommand("msdb.dbo.sp_send_dbmail", conn)
                {
                    CommandType = CommandType.StoredProcedure,
                    CommandTimeout = 500,
                })
                {
                    cmd.Parameters.AddRange(new[] { paramMailProfile, paramReceivers, paramCC, paramBody, paramSubject, paramFileAttachments });
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
              return;
            }
        }

c# 調用sqlserver sp_send_dbmail 預存程序 發送郵件