Welcome

Welcome Anonymous

Monday, September 20, 2010

How to Display Image from Database

//Retrieving image from Database
SqlCommand c = new SqlCommand();
c.CommandType = CommandType.StoredProcedure;
c.Connection = con;
c.CommandText = "sp_readImage";

int id =Convert.ToInt16( obj.executescalar("select max(photoid) from Photos"));


c.Parameters.AddWithValue("@id",id );
byte[] imagedata = (byte[])c.ExecuteScalar();
MemoryStream memory = new MemoryStream(imagedata);

// To display the image in the page itself
img =System.Drawing.Image .FromStream(memory);
img.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg );

// To Disaply image in image control(image1)

BinaryWriter t = new BinaryWriter(File.Open(Server.MapPath("Images\\sample.jpeg"),FileMode.Create ));
t.Write(imagedata);
t.Close();
Image1.ImageUrl = Server.MapPath("Images\\sample.jpeg");

No comments:

Post a Comment