Thanks guys. See anything here?
Here's the image control in the FormView:
<img id="imgPhoto" alt="No photo." src='ImageHandler.ashx?contactID=<
%# Eval("contact_id") %>' />
Here is uploading the binary data:
public void formviewContacts_OnInserting(object sender,
SqlDataSourceCommandEventArgs e)
{
int intLen =
((FileUpload)formviewContacts.FindControl("fileIma ge")).PostedFile.ContentLength;
byte[] bytImage = new byte[intLen];
if
(((FileUpload)formviewContacts.FindControl("fileIm age")).HasFile)
{
Response.Write(bytImage.Length.ToString());
((FileUpload)formviewContacts.FindControl("fileIma ge")).PostedFile.InputStream.Read(bytImage,
0, intLen);
SqlParameter param = new SqlParameter("@image",
SqlDbType.VarBinary);
param.Direction = ParameterDirection.InputOutput;
param.Value = bytImage;
e.Command.Parameters.Add(param);
}
}
....And here is my Handler class:
<%@ WebHandler Language="C#" Class="ImageHandler" %>
using System;
using System.IO;
using System.Web;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
public class ImageHandler : IHttpHandler {
public bool IsReusable {
get {
return true;
}
}
public static Stream GetPhoto2(int photoid)
{
using (SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrin gs["ConnectionString"].ConnectionString))
{
using (SqlCommand command = new SqlCommand("SELECT [Photo]
FROM [Contact] WHERE [contact_id]=@id", connection))
{
command.Parameters.Add(new SqlParameter("@id", photoid));
connection.Open();
object result = command.ExecuteScalar();
try
{
return new MemoryStream((byte[])result);
}
catch
{
return null;
}
}
}
}
public void ProcessRequest (HttpContext context)
{
//Set up the response settings
context.Response.ContentType = "image/jpeg";
context.Response.Cache.SetCacheability(HttpCacheab ility.Public);
context.Response.BufferOutput = false;
// Setup the PhotoID Parameter
Int32 id = -1;
Stream stream = null;
id = Convert.ToInt32(context.Request.QueryString["contactID"]);
stream = GetPhoto2(id);
const int buffersize = 1024 * 16;
byte[] buffer2 = new byte[buffersize];
int count = stream.Read(buffer2, 0, buffersize);
while (count 0) {
context.Response.OutputStream.Write(buffer2, 0, count);
count = stream.Read(buffer2, 0, buffersize);
}
}
}
