将数据库中的数据以固定格式Email出去 在asp.net中,我使用system.web.mail进行Email发送,但是我想将数据库中的数据以固定格式Email出去,整个过程全自动,应该如何实现? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 要像自动就在Global里面写好了.. 固定格式,你个用代码写.比如些个table 发出去的时候,就会有格式了. 写个控制台程序发送邮件。。把格式做成html,html包含很多标签。读html文件并用数据库中的内容替换标签window计划任务 try { string Noempty = "<p class=\"plaintext\">Personal message: <br />" + this.txtMessage.Text + "</p>"; string template = WebUtil.ReadTemplate(ConfigurationManager.AppSettings["TemplatePath"] + "emailTemplate.htm"); StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0} ({1}) has forwarded you a page from the InnoCentive website.", this.txtUserName.Text, this.txtEmail.Text); sb.Append("<br><br>"); if (!String.IsNullOrEmpty(this.txtMessage.Text)) { sb.Append("Personal Message:"); sb.Append("<br>"); sb.Append(this.txtMessage.Text); sb.Append("<br><br>"); } sb.Append(this.url.Substring(this.url.LastIndexOf(@"\") + 1)); sb.Append("<br>"); sb.Append("<a href=\"" + this.url + "\">" + this.url.Substring(this.url.LastIndexOf(@"\") + 1) + "</a>"); sb.Append("<br><br>"); sb.Append("www.innocentive.com"); WebUtil.SendEmail(this.txtFriendEmail.Text, this.txtEmail.Text, this.txtUserName.Text + " has forwarded you a page from InnoCentive.com.", sb.ToString()); Response.Write("<script>alert('send successfully');</script>"); } catch (Exception ex) { throw new Exception(ex.Message); } static public string ReadTemplate(string filePath) { StringBuilder sb = new StringBuilder(); try { using (StreamReader tempReader = new StreamReader(filePath, Encoding.UTF8)) { string line; while ((line = tempReader.ReadLine()) != null) { sb.Append(line); } tempReader.Close(); } } catch (Exception ex) { throw new Exception(ex.Message); } return sb.ToString(); } 配置web config禁止匿名用户登录 错误汇总控件的ShowMessageBox属性设置为True,但是在服务器不弹出提示框是怎么回事啊? 请教用","隔开的字符,如何取个数 ASP.NET 里面如何捕捉到Oralce Package里面写的的错误信息 如何保存一个窗口的变量 关于session的问题,高手来帮帮忙 如果发表留言和回复留言的页面是相同的,如何实现页面共用???代码具体要怎么写??? 有关button与验证的问题请教大侠 Table控件不好用啊 统计当前在线人数的问题 求asp.net2.0中取databind字段 关于dataset
固定格式,你个用代码写.比如些个table 发出去的时候,就会有格式了.
把格式做成html,html包含很多标签。
读html文件并用数据库中的内容替换标签
window计划任务
{
string Noempty = "<p class=\"plaintext\">Personal message: <br />" + this.txtMessage.Text + "</p>";
string template = WebUtil.ReadTemplate(ConfigurationManager.AppSettings["TemplatePath"] + "emailTemplate.htm");
StringBuilder sb = new StringBuilder();
sb.AppendFormat("{0} ({1}) has forwarded you a page from the InnoCentive website.", this.txtUserName.Text, this.txtEmail.Text);
sb.Append("<br><br>");
if (!String.IsNullOrEmpty(this.txtMessage.Text))
{
sb.Append("Personal Message:");
sb.Append("<br>");
sb.Append(this.txtMessage.Text);
sb.Append("<br><br>");
}
sb.Append(this.url.Substring(this.url.LastIndexOf(@"\") + 1));
sb.Append("<br>");
sb.Append("<a href=\"" + this.url + "\">" + this.url.Substring(this.url.LastIndexOf(@"\") + 1) + "</a>");
sb.Append("<br><br>");
sb.Append("www.innocentive.com"); WebUtil.SendEmail(this.txtFriendEmail.Text, this.txtEmail.Text, this.txtUserName.Text + " has forwarded you a page from InnoCentive.com.", sb.ToString());
Response.Write("<script>alert('send successfully');</script>");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
{
StringBuilder sb = new StringBuilder();
try
{
using (StreamReader tempReader = new StreamReader(filePath, Encoding.UTF8))
{
string line;
while ((line = tempReader.ReadLine()) != null)
{
sb.Append(line);
}
tempReader.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return sb.ToString();
}