Display varbinary as a downloadable link

Question

Fairly straightforward question, I have images stored in my database as varbinary and would like to provide a link to these images rather than displaying them on the website. When a user clicks the link he/she should be able to download the image.

Answer 1

An image is served in response to a request.

<img src="?" /> <!-- what goes here? -->

You need to create an HTTP handler to receive requests for these images.

A handler is an executable available at a specific URL which can respond to your request; in this case, by serving the binary data of an image. An ASPX page is a valid handler, though there are more efficient handler types for images.

<img src="MyHandler.aspx?imageId=123" />

The handler should do a few things:

• validate that the ID is valid and that the caller has permissions (if needed)
• retrieve the image from the database
• set appropriate response headers
• use Response.BinaryWrite() to send the binar data to the client.

Note that if you are using ASP.Net MVC, you can use a controller as your handler.

An alternative method is to base 64 encode the bytes and embed them directly in the image tag.

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUA
AAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO
9TXL0Y4OHwAAAABJRU5ErkJggg==" alt="Red dot">

This is a useful technique for small images or when the expense of multiple requests is very high.

See: http://en.wikipedia.org/wiki/Data_URI_scheme

More reading:

• Dynamically Rendering asp:Image from BLOB entry in ASP.NET
• Dynamic Image Generation

Answer 2

You should create a page that takes an image-id and returns the image.

Answer 3

You may consider this question:

Display image from a datatable in asp:image in code-behind

I had a similar problem an that answer solved my question. Beside that, you can use binaryimage component from Telerik:

http://www.telerik.com/products/aspnet-ajax/binaryimage.aspx