Picture from mysql to PictureBox

Asked Feb 12 '18 at 13:53

Active Feb 12 '18 at 13:53

Viewed 131 times

I'm trying to show image from mysql to PictureBox, and I set it to show on a form load. But when my form loads, picture doesn't appear, and the code shows no errors. Here's the code:

Private Sub frmStudentskiPanel_Load(sender As Object, e As EventArgs) Handles MyBase.Load

    Konekcija = New MySqlConnection
    Konekcija.ConnectionString = "server=localhost; userid=root; password=masterzlaja123; database=proba"
    Dim Command As MySqlCommand
    Dim reader As MySqlDataReader
    Dim img() As Byte

    Try
        Konekcija.Open()
        Dim Query As String
        Query = "Select Slika from proba.studenti where Korisnicko_ime = '" & Label2.Text & "' "
        Command = New MySqlCommand(Query, Konekcija)
        reader = Command.ExecuteReader
        While reader.Read()
            img = reader.Item("Slika")
            Dim mstream As New MemoryStream(img)
            PictureBox1.Image = Image.FromStream(mstream)
        End While

        Konekcija.Close()
    Catch ex As Exception
        MessageBox.Show(ex.Message)
    Finally
        Konekcija.Dispose()
    End Try

End Sub

End Class

asked Feb 12 '18 at 13:53

is the image column in MySQL a blob datatype? – Raymond Nijland Feb 12 '18 at 13:56
Did you debug, i.e. set a breakpoint and step through the code? Did `Read` return `True`? – jmcilhinney Feb 12 '18 at 14:02
By the way, you should be disposing that `MemoryStream`. – jmcilhinney Feb 12 '18 at 14:02
The image is the blob type – Feb 12 '18 at 14:04
how do I check reader value? – Feb 12 '18 at 14:11

Picture from mysql to PictureBox

0 Answers0