Preview/Show image from SQL Server in ASP.NET

Hi,
The simple way to read image from SQL Server is to use a handler (.ashx file)

write the below code in the ashx file as:

public void ProcessRequest(HttpContext context)
    {
        Int32 empno;
        if (context.Request.QueryString["id"] != null)
            empno = Convert.ToInt32(context.Request.QueryString["id"]);
        else
            throw new ArgumentException("No parameter specified");
        
        AccountType tblAccount = new AccountType();
        tblAccount.LoadByPrimaryKey(empno);

        context.Response.ContentType = "image/jpeg";
        Stream strm = new MemoryStream((byte[])tblAccount.HeaderLogo);
        byte[] buffer = new byte[4096];
        int byteSeq = strm.Read(buffer, 0, 4096);

        while (byteSeq > 0)
        {
            context.Response.OutputStream.Write(buffer, 0, byteSeq);
            byteSeq = strm.Read(buffer, 0, 4096);
        }        
    }

Here the AccountType is my Class and you should use your Product class Logics to pass the perameter.

and call the image as:

ImgHeaderLogo.ImageUrl = "~/HeaderLogo.ashx?id="YOURID";

If u want to use LINQ

http://debugmode.net/2010/05/10/inserting-and-retrieving-image-using-linq-to-sql-from-asp-net-application/[^]

No solution yet!!!
I`m following all the steps, but somewhere is a problem and I can`t figure it out :(
So, I`m going to specife my program structure in details, so maybe someone will now what is wrong with it.
I have a table PRODUCTS which has foreign key ImageFK on IMAGE table.
IMAGE table ID is nchar(10), also ImageFK in PRODUCTS is nchar(10).

In one aspx page I have a listview of my products with some records (f.e. Product Name, Product Price..) and I want also to show my product image.
So the query which is bind to this listview go like this:

var query=(from x in Products
select new 
{
x.Id, //Product ID
x.ProductName,
x.ProductPrice,
x.ImageFK //Foreign key for IMAGE table

}).ToList();
return query;

Everything is shown perfectly, beside Image :(

I`ve created ashx page "ImageShow.ashx", the code is shown below: //

public class ImageShow : IHttpHandler
   {

       public Stream ShowEmpImage(string id)
       {
           using (DCKlaseDataContext dc = new DCKlaseDataContext())
           {

               var queryImage = (from x in dc.Images    // find image where id`s are the same (id in Product table and Id in Image table)
                           where x.Id == id
                           select x).FirstOrDefault();


               return new MemoryStream(queryImage.Image.ToArray());


           }

       }
       public void ProcessRequest(HttpContext context)
       {
           string id = context.Request.QueryString["ImageFK"].ToString();


               context.Response.ContentType = "image/jpeg";

              Stream strm = ShowEmpImage(id);

              byte[] buffer = new byte[4096];
              int byteSeq = strm.Read(buffer, 0, 4096);

            while (byteSeq > 0)

            {

               context.Response.OutputStream.Write(buffer, 0, byteSeq);

                 byteSeq = strm.Read(buffer, 0, 4096);

             }

       }

And final step is on my image field in my aspx page, to add image url (which is this ashx page):

<asp:image id="img_1" runat="server" imageurl="ImageShow.ashx?ImageFK=<%# Eval("ImageFK") %>" xmlns:asp="#unknown" />

And when I build the program, it show error on

return new MemoryStream(queryImage.Image.ToArray());

with message: Object reference not set to an instance of an object.

Anyone?!

Thank you..