how to update image using database in vb.net

Question

what is the problem of this code?? i got a error for the GDI+ and i dont know to solve.

Private Sub saveEmployee()
   Dim ms As New MemoryStream

   PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)--i got error in this line..A generic error occurred in GDI+.

   Dim arrPic() As Byte = ms.GetBuffer()

   Dim cmdEmp As New MySqlCommand
   Dim sqlEmp As String
   sqlEmp = "update tbl_employee set  emPic=@emPic where emID='" & lbl_empID.Text & "'"

   With cmdEmp
      .Parameters.AddWithValue("@emPic", arrPic)
      .ExecuteNonQuery()
   End With
End Sub

You need to learn how to use the debugger. Which line is causing the error? what is the error exactly ? Your question is prone to closing if you don't add more details soon. — Abdusalam Ben Haj
– Abdusalam Ben Haj, Commented Feb 24, 2013 at 14:17
the error is in thus line PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat) — Rodmar Pusung
– Rodmar Pusung, Commented Feb 24, 2013 at 14:19

Abdusalam Ben Haj · Accepted Answer · 2013-02-24 14:41:46Z

1

Try replacing that line with this :

Dim bm as Bitmap = new Bitmap(PictureBox1.Image)
bm.Save(ms, PictureBox1.Image.RawFormat)

The reason could be that the Image is being used by the PictureBox. Its also good practice to have the following instead :

Using ms As MemoryStream = New MemoryStream()

   Dim bm as Bitmap = new Bitmap(PictureBox1.Image)
   bm.Save(ms, PictureBox1.Image.RawFormat)

   Dim arrPic() As Byte = ms.GetBuffer()

   Dim cmdEmp As New MySqlCommand
   Dim sqlEmp As String
   sqlEmp = "update tbl_employee set  emPic=@emPic where emID=@emID"

   With cmdEmp
     .Parameters.AddWithValue("@emPic", arrPic)
     .Parameters.AddWithValue("@emID", int.Parse(lbl_empID.Text))
     .ExecuteNonQuery()
   End With

End Using

This way the MemoryStream will get Disposed after being used. And adding @emID as a parameter is safer.

edited Feb 24, 2013 at 14:41

answered Feb 24, 2013 at 14:34

Abdusalam Ben Haj

5,4515 gold badges33 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Samuel Darteh · Accepted Answer · 2016-01-18 00:08:09Z

0

RESOLVED!!! Bind picture box to the datasource field using the Advance tab in the DataBindings section. Use the ImageLocation property instead of image. Then change the Update mode to NEVER. but how abt the update ??? Use a textbox and hide behind the Picture box [with visible = true]. Bind textbox to same datasource. THAT IS!!!

image displays directly in picture box whilst the textbox TextChanged property handles whether there is UPDATE or Not. took me a while but it works fine now. good luck as u code... ~ SAM, GHANA

answered Jan 18, 2016 at 0:08

Samuel Darteh

492 bronze badges

Collectives™ on Stack Overflow

how to update image using database in vb.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related