//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(); Ima...
Comments
Post a Comment