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 roei,actually 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 ?

retrieving image from database to image control

Answers (5)