如何将 SQL Server 中存储为二进制对象的 PDF 文件附加到电子邮件中？

发布于 2024-09-05 05:56:29 字数 693 浏览 7 评论 0原文

我想将在 SQL Server 中作为二进制对象存储的 PDF 文件附加到电子邮件，但不在磁盘上创建（临时）文件。

我已经完成了从 SQL Server 中的二进制字段中以 byte[] 数组形式提取 PDF 文件的第一步。

另外，我还有设置 MailMessage 的步骤：

MailMessage aMailMessage = new MailMessage();
// set address, subject, body
aMailMessage.Attachments.Add(attachment);

我陷入困境的是 attachment 对象：

Attachment attachment = new Attachment(... what goes here? ...);

Attachment 的构造函数主要接受 >string fileName （我没有但不想要）或 System.IO.Stream contentStream。

所以我的问题是：使用给定的 byte[] 数组是否可以在磁盘上没有中间文件的情况下创建正确的 Attachment 对象，我需要执行哪些步骤？

先感谢您！

原文

I'd like to attach a PDF file stored as binary object in SQL Server to an email but without creating a (temporary) file on disk.

I already have the first step to pull out the PDF file from the binary field in SQL Server as a byte[] array.

Also I have the step to setup the MailMessage:

MailMessage aMailMessage = new MailMessage();
// set address, subject, body
aMailMessage.Attachments.Add(attachment);

Where I am stuck is the attachment object:

Attachment attachment = new Attachment(... what goes here? ...);

The constructor of Attachment accepts mainly either a string fileName (which I don't have and want) or a System.IO.Stream contentStream.

So my question is: With a given byte[] array is it possible to create the proper Attachment object without an intermediary file on disk and what steps do I have to do?

Thank you in advance!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟柳画桥 2024-09-12 05:56:29

您可以将 byte[] 转换为 MemoryStream 并创建 附件 实例。这是一个例子：

ContentType ct = new ContentType(MediaTypeNames.Application.Pdf);
MemoryStream pdf = new MemoryStream(pdfContent);
Attachment data = new Attachment(pdf, ct);

You can convert byte[] to MemoryStream and create Attachment instance from it. Here is an example:

ContentType ct = new ContentType(MediaTypeNames.Application.Pdf);
MemoryStream pdf = new MemoryStream(pdfContent);
Attachment data = new Attachment(pdf, ct);

回复收藏 0 原文

~没有更多了~