how can i retrieve image from database?

[rucel jhalia]

Private Sub RetrieveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RetrieveButton.Click

    conn = New MySqlConnection
    conn.ConnectionString = "server=127.0.0.1; Port=3306; user id=root; password=; database=bsit3d"
    Dim READER As MySqlDataReader
    Dim Command As New MySqlCommand

    conn.Open()

    Dim Query As String

    Query = "select * from bsit3d.form where username= '" & username.Text & "' "
    Command = New MySqlCommand(Query, conn)
    READER = Command.ExecuteReader

    Dim arrImage() As Byte

    While READER.Read

        StudentID.Text = READER.GetString("studentID")
        Lastname.Text = READER.GetString("lastname")
        Firstname.Text = READER.GetString("firstname")
        Middlename.Text = READER.GetString("middlename")
        Birthdate.Text = READER.GetString("birthday")
        Age.Text = READER.GetString("age")
        Address.Text = READER.GetString("address")
        ComboBox1.Text = READER.GetString("gender")
        Emailadd.Text = READER.GetString("emailadd")
        Religion.Text = READER.GetString("religion")
        password.Text = READER.GetString("password")

        READER.Read()
        arrImage = READER.Item("image")
        Dim mstream As New System.IO.MemoryStream(arrImage)
        PictureBox2.Image = Image.FromStream(mstream)
        READER.Close()


    End While

    MessageBox.Show("Student's information is shown.")

    conn.Close()
    conn.Dispose()
End Sub

[savedlema]

-You didn't say what error do you get from that code.
-You can store your images somewhere in a folder and only store the path to that folder in your database.

[Mr.M]

You haven't said where are you having difficulties. But check this for saving and retrieving image from SQL Server.

http://www.codeproject.com/Articles/437937/Save-and-Retrieve-Image-from-a-SQL-Server-Database

[rucel jhalia]

sorry. im getting a hard time on this

[savedlema]

Sorry, I don't use your way but, did you try setting the image source to "mstream", it appears to me like you have declared "mstream" to hold the image source?

[Mr.M]

Check the below code. You need to pull the image.

 Dim connection As New SqlConnection("connection string here")
 Dim command As New SqlCommand("SELECT Picture FROM MyTable
 WHERE ID = 1", connection)

 connection.Open()

 Dim pictureData As Byte() = DirectCast(command.ExecuteScalar(),
 Byte())

 connection.Close()

 Dim picture As Image = Nothing

 'Create a stream in memory containing the bytes that comprise
 the image.
 Using stream As New IO.MemoryStream(pictureData)
 'Read the stream and create an Image object.      from the data.
 picture = Image.FromStream(stream)
 End Using

Note how image is read from database before displaying.