How to retrieve/display multiple images f database

sanjee2 — Thu, 21 Dec 2006 01:48:17 +0800

hi, i need help.

im facing the problem of displaying multiple images from my database(sql server 2000), i only allow to display only 1 image. could somebody help me?

This is the coding that im using. but only can display 1 image.
retrieve and insert code.
System.Int32 _height = 110;
System.Int32 _width = 200;
string sqlComm ="SELECT UploadID,UploadImage FROM images_upload";

sqlConnection1.Open();
SqlCommand command = new SqlCommand(sqlComm,sqlConnection1);

SqlDataReader dr;
dr = command.ExecuteReader();

Response.ContentType = "image/jpeg";

while (dr.Read())
{
System.Drawing.Image _image= System.Drawing.Image.FromStream( new System.IO.MemoryStream( (byte[])dr["UploadImage"] ) );

System.Drawing.Image _newimage = _image.GetThumbnailImage( _width, _height, null, new System.IntPtr() );

_newimage.Save( System.Web.HttpContext.Current.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg );

}

dr.Close();
sqlConnection1.Close();

ps: beside save the picture in binary, is that hv other method? thanks.

Lowyat.NET: Latest topics by sanjee2

How to retrieve/display multiple images f database