Hi all, and Kevin in particular,
here's a source for the HTTP handler that picks
the image files from a database (this case *.png) and
handles it over to an image on a Webform with
Image.ImageURL= "...ashx" (although you could rightaway
also set the src-attribute of an <img/>-element.
Figure around: the pics wont show up on the WebForm.
What's the cause? - The ViewState?
Thanks for response
Detlef
--
<%@ WebHandler Language="C#" Class="PicViewe r" %>
using System;
using System.Web;
using System.Drawing;
using System.Drawing. Imaging;
using System.Data;
using System.Data.Sql Client;
using System.IO;
using System.Componen tModel;
public class PicViewer : IHttpHandler
{
public void ProcessRequest( HttpContext context)
{
System.Data.Sql Client.SqlConne ction
sqlConnInvoice;
Graphics g;
Bitmap bmp;
MemoryStream bmpStream;
Image _img;
MemoryStream memStream;
byte[] _picBytes;
//Get PicBytes, in this case Png Data,
where PngPic is a
//SQL-DataField of SQL format Image
conn = new
System.Data.Sql Client.SqlConne ction();
conn.Connection String = "...yerkyerk... ";
sqlConnInvoice. Open();
System.Data.Sql Client.SqlComma nd
_cmdLoadPicture =
new
System.Data.Sql Client.SqlComma nd("select PngPic from
PngPictures where PicID=52531;",c onn);
SqlDataReader drReader =
_cmdLoadPicture .ExecuteReader( );
drReader.Read() ;
_picBytes=(byte[])drReader.GetSq lBinary(0);
//Push data to Memory Stream
memStream = new MemoryStream();
memStream.Write
(_picBytes,0,_p icBytes.Length) ;
//Commented to follow a more general route:
//Make a Bitmap, print image into it and
save
//it into another standard format, here
*.gif,
//but could be any other
/*
//Construct image to push into response
stream
_img=Image.From Stream(memStrea m,true);
*/
//Read image size
float _height = Image.FromStrea m
(memStream).Phy sicalDimension. Height;
float _width = Image.FromStrea m
(memStream).Phy sicalDimension. Width;
//new Bitmap - adapt size if necessary:
bmp = new Bitmap(Image.Fr omStream
(memStream), new Size((int)_widt h, (int)_height));
g = Graphics.FromIm age (bmp);
//Draw on Bitmap
g.DrawImage(_im g,0,0);
memStream.Close ();
conn.Close();
/*
context.Respons e.ContentType = "image/gif";
//Save _img into Reponse stream - try
other format
_img.Save
(context.Respon se.OutputStream ,ImageFormat.Gi f);
*/
//Save bmp into Reponse stream
context.Respons e.ContentType=" image/gif";
bmp.Save(contex t.Response.Outp utStream,
System.Drawing. Imaging.ImageFo rmat.Gif);
bmp.Dispose();
g.Dispose();
}
public bool IsReusable
{
get { return true; }
}
}
//----------
