Hi ,

 I'm trying to call an image from sql server. How can I do it with out using a dataggrid or a gridview. I want to display one image at a time upon a button click.

 The image should also refer to an id given by a textbox. Anyone can help me ??

Hi,
if u are using datareader to read database record then u can use this code,

(byte[])(mSqlDataReader["ColumnName"].Equals(System.DBNull.Value) ? null : mSqlDataReader["ColumnName"])

Now u hav a byte array containg your image data.

byte[] bytView = AboveByteArray;
MemoryStream imgStreamView = new MemoryStream();
imgStreamView.Write(bytView, 0, bytView.Length);
System.Drawing.Bitmap bmpView = new System.Drawing.Bitmap(imgStreamView);
context.Response.ContentType = "image/jpeg";
bmpView.Save(context.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
imgStreamView.Close();

I hope this code will be usefull.
Regards,
Anuj rathi

Thanx for the help Anuj rathi , I'll try to do it first

Dear anujrathi ..

I've tried your solution to the problem, but it didn't work . Maybe there's some mistake in my part on putting the codes at the wrong place. So .. to confirm , where should the codes go ? and also , your codes does not specify any database or connection to any event upon displaying the image.

There's a solution in the internet : http://www.sqlteam.com/article/images-and-sql-server

that provide the similar solution .. Thank you for your time.

Regards,

-kutel-