Image into SQL 2005

[lance59]

I have this code but gives me an error on the insert statement. User selects image from file which loads into picturebox. I then pull out the image to store in SQL 2005.

If have_image = True Then
                Dim ms As New MemoryStream
                PictureBox3.Image.Save(ms, PictureBox3.Image.RawFormat)
                Dim itemImage() As Byte = ms.GetBuffer
                ms.Close()

                Dim cn2 As New SqlConnection(insert_conn_string)
                Dim objCommand2 As New SqlCommand("", cn2)
                cn2.Open()
                objCommand2.CommandText = "INSERT INTO images(stored_image,image_guid) VALUES(itemImage,'" & strGUID & "')"
                objCommand2.ExecuteNonQuery()
                cn2.Close()
                cn2 = Nothing
            End If

I believe I am not formatting the itemImage variable in the insert line, but I need help. Maybe better to pull image from file rather then picturebox?


TIA

 

[jebenson]

Check out this article, especially the uploadFileToDatabase function.

http://www.vbdotnetheaven.com/Uploa...rticleID=7ed1fe42-0819-4912-88ae-bbc43829d8a6

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!