Sending email with embedded image stored in the database.

See more:

embedded

C#

email

Hi,

My application is already sending email with embedded image, but this time the images were all stored in a database.
I can't figure it out on how to read and process the stored image to be part of the email.

Thanks in advance

What I have tried:

below code is for reading image from file path.

using (FileStream fileStream = new FileStream(Server.MapPath("~/" + fname), FileMode.Open, FileAccess.Read))
{
  content = new byte[fileStream.Length];
  fileStream.Read(content, 0, content.Length);
}

fileAttach.Content = content;

                CreateAttachmentType attachmentRequest = new CreateAttachmentType();
                attachmentRequest.Attachments = new AttachmentType[1];
                attachmentRequest.Attachments[0] = fileAttach;
                attachmentRequest.Attachments[0].IsInline = true;
                attachmentRequest.Attachments[0].ContentId = FileName;
                attachmentRequest.ParentItemId = emailResponseMessage.Items.Items[0].ItemId;