首先添加命名空間using System.Net.Mail;using System.Data.SqlClient;代碼其實很簡單,當然我這個功能比較簡單就是一個單擊事件
protected void btn_send_Click(object sender, EventArgs e)
...{
MailMessage message = new MailMessage();
//擷取寄件者地址
message.From = new MailAddress(tbx_address.Text.Trim());
//擷取主題
message.Subject = tbx_subject.Text.Trim();
//擷取發送郵件主題
message.Body = we_content.Text.Trim();
message.IsBodyHtml = true;
//設定資料庫連結
SqlConnection conn = new SqlConnection(getstring());
conn.Open();
//資料查詢用的是預存程序
SqlCommand cmd = new SqlCommand("SelectEmail", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter dutyparameter = cmd.Parameters.Add("@MemberDuty", SqlDbType.NVarChar, 20);
dutyparameter.Value = ddl_selectemail.SelectedValue;
SqlDataReader dr = cmd.ExecuteReader();
//執行查詢獲得要發往的郵件地址
while (dr.Read())
...{
message.To.Add(dr["MemberEmail"].ToString());
}
conn.Close();
SmtpClient client = new SmtpClient();
client.Send(message);
lbl_info.Visible = true;
lbl_info.Text = "發送成功";
}
另外在web。config設定發送郵件的遠程伺服器串連
代碼如下
<system.net>
<mailSettings>
<smtp>
<network host="smtp.163.com" port="25" userName="你的163帳號" password="你的密碼" />
</smtp>
</mailSettings>
</system.net>