title: retrieving image from database
body: <p>I'm working on my project which displays a list of employee. here, the information and picture of the employee will be shown. my project can now show the list of employees in the listbox and when I double click on an employee, his/her profile will be shown on a textbox. my problem is that i can't make their pictures to show in the <code>picturebox</code>. I already stored their picture on a table in my database along with their id, name, and profile. <code>It only shows the picture of the first employee on the table</code>. can anybody help me?</p>
  
  <p>here's what I already done:</p>
  
  <p>I populated the listbox:</p>
  
  <pre><code>Call Connect() 
      With Me
          STRSQL = "Select employee_name from Employees"
          Try
              myCmd.Connection = myConn
              myCmd.CommandText = STRSQL
              reader = myCmd.ExecuteReader
              If (reader.Read()) Then
                  reader.Close()
                  adptr.SelectCommand = myCmd
                  adptr.Fill(dt)
                  lstEmployee.DisplayMember = "employee_name"
                  lstEmployee.ValueMember = "employee_id"
                  If dt.Rows.Count &gt; 0 Then
                      For i As Integer = 0 To dt.Rows.Count - 1
                          lstEmployee.Items.Add(dt.Rows(i)("employee_name"))
                      Next
                  End If
              End If
          Catch ex As Exception
              MsgBox(ex.Message)
          End Try
      End With
  </code></pre>
  
  <p>here's how I show the info on textbox</p>
  
  <pre><code>Dim FileSize As UInt32
      Dim mStream As New System.IO.MemoryStream()
      Dim arrImage() As Byte = mStream.GetBuffer()
      FileSize = mStream.Length
      Dim cmd As New MySqlCommandBuilder
      Call Connect()
      With Me
          STRSQL = "select employee_name, profile from Employees where employee_id = " &amp; lstEmployee.SelectedIndex
          Try
              myCmd.Connection = myConn
              myCmd.CommandText = STRSQL
              reader = myCmd.ExecuteReader
  
              If (reader.Read()) Then
                  txtName.Text = reader("employee_name")
                  txtProfile.Text = reader("profile")
              End If
          Catch ex As Exception
              MsgBox(ex.Message)
          Finally
              myConn.Close()
          End Try
          adptr.SelectCommand = myCmd
          dt = New DataTable
          adptr = New MySqlDataAdapter("select picture from Employees", myConn)
          cmd = New MySqlCommandBuilder
          adptr.Fill(dt)
          Dim lb() As Byte = dt.Rows(0).Item("picture")
          Dim lstr As New System.IO.MemoryStream(lb)
          pix.Image = Image.FromStream(lstr)
          pix.SizeMode = PictureBoxSizeMode.StretchImage
          lstr.Close()
  </code></pre>