how to display an image from database access??

Attachment Size
untitled-34.jpg 30.67 KB
this is my coding for the search button where actually i want all the details for the searched staff will be display Try sql = "SELECT * FROM Staff WHERE staff_ic = '" & sticnumbertxt2.Text & "'" con.Open() Dim cmd As OleDbCommand Dim dr As OleDbDataReader cmd = New OleDbCommand(sql, con) dr = cmd.ExecuteReader While dr.Read() stnametxt2.Text = dr("staff_name") staddresstxt2.Text = dr("staff_address") stpostcodetxt2.Text = dr("staff_postcode") ststatetxt2.Text = dr("staff_state") stcontacttxt2.Text = dr("staff_contact") stphonetxt2.Text = dr("staff_phone") staffid.Text = dr("staff_id") staffPictureBox2.Image = dr("staff_image") End While Catch ex As Exception MessageBox.Show(ex.Message) End Try con.Close()

Add new comment