Databases
StackOverflow2013
Postsdbo
POattach multiple files to an email programticaly without writing to disk
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POattach multiple files to an email programticaly without writing to disk
    text
    copied!<p>Our project has files stored in a sql server db as blobs. I'd like to get the files from the database and attach multiple files to an email without writing to disk. </p> <p>This is what I have so far(everything works ok, with no attachments):</p> <pre><code>// snip List&lt;System.Net.Mail.Attachment&gt; attachments = null; // Attachments is a child list of Messagebody object holding Attachment ids MessageBody.Attachments = MessageBodyAttachmentList.GetMessageBodyAttachmentList(this.MessageBody.ID); if (MessageBody.Attachments != null &amp;&amp; MessageBody.Attachments.Count &gt; 0) { attachments = new List&lt;Attachment&gt;(); foreach (Library.Entity.Messaging.MessageBodyAttachment att in MessageBody.Attachments) { using (MemoryStream memoryStream = new MemoryStream()) { // create a new attachment Library.Attachments.Attachment attachment = Library.Attachments.Attachment.GetAttachment(att.AttachmentID); byte[] contentAsBytes = attachment.FileData;// FileData holds byte[] that is the contents of the file memoryStream.Write(contentAsBytes, 0, contentAsBytes.Length); memoryStream.Seek(0, SeekOrigin.Begin); // content type for file info ContentType contentType = new ContentType(); contentType.MediaType = MediaTypeNames.Application.Octet; contentType.Name = attachment.FileName; // create the .Net specific attachment Attachment netAttachment = new Attachment(memoryStream, contentType); attachments.Add(netAttachment); memoryStream.Position = 0; } } } response = message.SendMessage(_recipient, _sender, _cc, _bcc, MessageBody.Subject, MessageBody.Body, true, attachments); // snip public string SendMessage(string to, string from, string cc, string bcc, string subject, string body, bool IsHtml, List&lt;Attachment&gt; attachments) { string response = String.Empty; System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage(from, to, subject, body); // Add the attachments if (attachments != null) { foreach (Attachment a in attachments) message.Attachments.Add(a); } message.IsBodyHtml = IsHtml; if (IsHtml) { // snip } try { _client.Timeout = 500000; _client.Send(message); } catch (SmtpException smtpex) { response = smtpex.Message; } catch (System.Exception ex) { response = ex.Message; } return response; } </code></pre> <p>I'm getting the following errors:</p> <pre><code>exception message: Failure sending mail. source: System stack trace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at MyCompany.Shared.Email.SMTPMessage.SendMessage(String to, String from, String cc, String bcc, String subject, String body, Boolean IsHtml, List`1 attachments) in C:\svn_repos\branches\2010.02.28\Net\Common\Shared\Email\SMTPMessage.cs:line 116 inner exception msg: Cannot access a closed Stream. inner source: mscorlib inner targetsite: {Void StreamIsClosed()} inner stack trace: at System.IO.__Error.StreamIsClosed() at System.IO.MemoryStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.Net.Mime.MimePart.Send(BaseWriter writer) at System.Net.Mime.MimeMultiPart.Send(BaseWriter writer) at System.Net.Mail.Message.Send(BaseWriter writer, Boolean sendEnvelope) at System.Net.Mail.MailMessage.Send(BaseWriter writer, Boolean sendEnvelope) at System.Net.Mail.SmtpClient.Send(MailMessage message) </code></pre> <p>I copied most of the stream code from examples I found on the web.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload