c# - 使用 C# 和 ASP.NET 在电子邮件附件中发送 SQL 报告

Question

我正在尝试使用 ASP.NET 和 C# 从 sql reportserver 2008 作为电子邮件附件发送报告，到现在为止我学会了如何Get report as PDF在我的代码中，现在我想结合一行代码，比如

byte[] bytes = rview.ServerReport.Render(format, deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
Response.OutputStream.Write(bytes, 0, bytes.Length);
Attachment reportAttachment = new Attachment(Response.OutputStream.Write(bytes,0,bytes.Length),"ado"); //Here I go wrong

提前致谢

Answer 1

与其先将 pdf 保存到文件系统，不如尝试使用从报表服务器返回的 byte[] 并附上:

MemoryStream ms = new MemoryStream(bytes); 
mail.Attachments.Add(new Attachment(ms, "temp.pdf"));

为了快速捏造我的一份报告，我做了以下事情:

WebClient client = new WebClient();
byte[] bytes = client.DownloadData("http://localhost/ReportServer/Pages/ReportViewer.aspx? *** report name *** &rs%3aFormat=PDF");
MemoryStream ms = new MemoryStream(bytes);
mail.Attachments.Add(new Attachment(ms, "temp.pdf"));

希望对你有帮助