Hi, I just wanna ask what's the problem with my code in retrieving image from database into a picturebox.
Private Sub ShowDetails()
Try
Dim cn As New OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand
Dim dr As OleDb.OleDbDataReader
cn.ConnectionString = mstrConnection
cn.Open()
cmd = cn.CreateCommand()
cmd.CommandText = "SELECT myimage FROM employees WHERE ID = '" & DataGridView.CurrentRow.Cells(0).Value & "'"
dr = cmd.ExecuteReader
If dr.Read Then
Dim bytImage() As Byte
Try
bytImage = CType(dr(0), Byte())
Dim ms As New System.IO.MemoryStream(bytImage)
Dim bmImage As New Bitmap(ms)
ms.Close()
myimage.Image = bmImage
myimage.Refresh()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End If
dr.Close()
cn.Close()
cmd.Dispose()
cn.Dispose()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub