C#

Pete O'Hanlon wrote:

it's just plain bad practice coupling the view to the database like this

// Create a mail message<br />
MailMessage mm = new MailMessage();<br />
<br />
// Add To, From, Subject here…<br />
<br />
// Add the body as an AlternateView<br />
AlternateView av = AlternateView.CreateAlternateViewFromString(body, Encoding.Unicode, "text/html");<br />
// Include a reference to the image in the body string like so:<br />
// <img src=cid:signature ="signature" /><br />
<br />
// Create a linked resource<br />
imageStream = new MemoryStream(resourceImageBytes, false);<br />
LinkedResource imageResource = new LinkedResource(imageStream);<br />
imageResource.ContentId = "signature";<br />
imageResource.ContentType = new ContentType("image/jpeg");<br />
<br />
// Add the linked resource to the Alternative view<br />
av.LinkedResources.Add(imageResource);<br />
<br />
// Add AlternateView to the MailMessage<br />
mm.AlternateViews.Add(av);