I have a project in VB2010 it is well connected to the database (DB.accdb) access2007.
I'm trying to save the photo into the database table using Binary method.
I am successfully able to (Save, Search).
my problem is in the EDIT button :
I'm supposed to search first to return\display the info+Photo on the form controls (Textbox + PictureBox), now i want to do EDIT, i use sql string :
SqlStr = "Update MyTable Set Field1 = '" & Text1.Text & "', PhotoOle = [b]????[/b]"
I'm not able to convert the PictureBox That contains the returned photo to Byes() using :
ImageBytes = Ctype(PictureBox1.Image, Byte()).... not working .
ImageBytes = Ctype(DaraRead!PhotoOle, Byte()).... not working either.