retrieve images from database (c# windows)

Question

how to retrieve image from sql server db and save it to my picture box

manoj kumar · Answer

Hi ..u can use this code for save and retrieve... private int SaveToDB(string imgname byte[] imgbin string imgcontenttype) { SqlCommand command=new SqlCommand (insert into myimages(imgnameimgfileimgtype) values (@img_name@img_file@img_type)connection); SqlParameter param0=new SqlParameter (@img_nameSqlDbType.VarChar 30); param0.Value =imgname; command.Parameters .Add (param0); SqlParameter param1=new SqlParameter (@img_fileSqlDbType.Image); param1.Value =imgbin; command.Parameters .Add (param1); SqlParameter param2=new SqlParameter (@img_typeSqlDbType.VarChar 30); param2.Value =imgcontenttype; command.Parameters .Add (param2); connection.Open(); int num=command.ExecuteNonQuery (); Response.Write(Image has stored); connection.Close (); return num; } protected void Button2_Click(object sender System.EventArgs e) { connection.Open(); SqlCommand command1 = new SqlCommand(select imgfileimgname from myimages where imgname=@param  connection); SqlParameter myparam =command1.Parameters .Add (@paramSqlDbType.VarChar 30); myparam.Value=txtimgname.Text ; byte[] img=(byte[])command1.ExecuteScalar(); MemoryStream str=new MemoryStream(); str.Write (img0img.Length ); Bitmap bit=new Bitmap (str); Response.ContentType =image/jpeg;//or you can select your imagetype from database or directly write it here bit.Save (Response.OutputStream ImageFormat.Jpeg); connection.Close (); } if you dnt satis fied this code..u can chk my attch fils article..

Santhosh N · Answer

get the images to listbox first as below.. Me.SqlConnection1.Open() Me.SqlDataAdapter1.Fill(Me.DataSet11.Pic) With Me.ListBox1 .DataSource = Me.DataSet11.Pic .DisplayMember = Name End With Me.SqlConnection1.Close() Now assign the image to picturebox Private Sub ListBox1_SelectedIndexChanged(ByVal sender As Object _ ByVal e As System.EventArgs) _ Handles ListBox1.SelectedIndexChanged Dim arrayImage() As Byte = CType(Me.DataSet11.Tables(0).Rows(Me.ListBox1.SelectedIndex) _ (Picture) Byte()) Dim ms As New MemoryStream(arrayImage) With Me.PictureBox1 .Image = Image.FromStream(ms) .SizeMode = PictureBoxSizeMode.CenterImage End With End Sub

Lalit M · Answer

there are two way to save image in picture box. 1) Use the System.Drawing.Image method Save to save as a file. Choose the image format to save it to(e.g. bitmap png gif etc.) 2) Use a FileStream to write the memory stream to a file. The memory stream is already properly formatted as an image. There is no need to decode and encode it unless you wish to save it as a different image format. How to show this link