retrieving image from database to image control

Question

I need to retreive an image from the database and load it into an Image control on a web page i need ideas like yesterday!

Kirtan Patel · Answer

using System.IO; using System.Drawing.Imaging; using System.Drawing; protected void btnImage_Click( object sender EventArgs e) { SqlConnection con = new SqlConnection ( @Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True ); con.Open(); SqlCommand comm = new SqlCommand ( select Picture from Users where ID=1  con); byte [] imagedata = (( byte [])comm.ExecuteScalar()); MemoryStream m = new MemoryStream (imagedata); Bitmap image = new Bitmap (stream); //takeing type Response.ContentType = image/gif ; //showing image.Save(Response.OutputStream ImageFormat .Gif); DataBind(); }

akomolafe Adesina · Answer

yeah i already use varbinary as the datatype and i want to load the image onto a web page

akomolafe Adesina · Answer

thanms roeiactually iwant to use the code on a web page thus the picture box control will not be suitable

Roei Bar · Answer

here you go : private void btnLoad_Click( object sender System.EventArgs e) { try { SqlCommand cmdSelect=new SqlCommand(  select Picture +  from tblImgData where ID=@ID  this .sqlConnection1); cmdSelect.Parameters.Add(  @ID SqlDbType.Int 4 ); cmdSelect.Parameters[  @ID ].Value=this.editID.Text; this .sqlConnection1.Open(); byte [] barrImg=( byte [])cmdSelect.ExecuteScalar(); string strfn=Convert.ToString(DateTime.Now.ToFileTime()); FileStream fs=new FileStream(strfn FileMode.CreateNew FileAccess.Write); fs.Write(barrImg 0 barrImg.Length); fs.Flush(); fs.Close(); pictureBox1.Image=Image.FromFile(strfn); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this .sqlConnection1.Close(); } }

Kirtan Patel · Answer

Hello  How you Stored image in database in VarBinary ?? or any other way ?