I usually create an image handler class(.ashx file):
public class ImageFromDB : IHttpHandler {
public void ProcessRequest(HttpContext context) {
string connectionString =
WebConfigurationManager.ConnectionStrings["Pubs"].ConnectionString;
// Get the ID for this request.
string id = context.Request.QueryString["id"];
if (id == null) throw new ApplicationException("Must specify ID.");
// Create a parameterized command for this record.
SqlConnection con = new SqlConnection(connectionString);
string SQL = "SELECT logo FROM pub_info WHERE pub_id=@ID";
SqlCommand cmd = new SqlCommand(SQL, con);
cmd.Parameters.AddWithValue("@ID", id);
try {
con.Open();
SqlDataReader r =
cmd.ExecuteReader(CommandBehavior.SequentialAccess);
if (r.Read()) {
int bufferSize = 100; // Size of the buffer.
byte[] bytes = new byte[bufferSize]; // The buffer.
long bytesRead; // The # of bytes read.
long readFrom = 0; // The starting index.
// Read the field 100 bytes at a time.
do {
bytesRead = r.GetBytes(0, readFrom, bytes, 0, bufferSize);
context.Response.BinaryWrite(bytes);
readFrom += bufferSize;
} while (bytesRead == bufferSize);
}
r.Close();
}
finally {
con.Close();
}
}
public bool IsReusable {
get { return true; }
}
}
You will then need to register the handler in the web.config file:
<httpHandlers>
<add verb="GET" path="ImageFromDB.ashx" type="ImageFromDB" />
</httpHandlers>
You should then be able to call the image as follows:
<img src="ImageFromDB.ashx?ID=1389" />