Kalau mau praktek, siapkan 1 project, 1 form, 1datagridview (name=djieDatagriView1), 1 picturebox (name=djiePictureBox1), saya menggunakan database northwind sqlserver.
Di form load kita koneksikan ke database dan load data ke datagridview :
Dim CON As New Odbc.OdbcConnection
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.LoadCON.ConnectionString = String.Format("DRIVER={0};SERVER={1};DATABASE={2};TRUSTED_CONNECTION=YES", "SQL SERVER NATIVE CLIENT 10.0", "DJIESOFT\SQL2008", "NORTHWIND")
CON.Open()
Dim ADP As New Odbc.OdbcDataAdapter("SELECT FIRSTNAME,PHOTO FROM EMPLOYEES", CON)
Dim DT As New DataTable
ADP.Fill(DT)
djieDataGridView1.DataSource = DT
End Sub
Selanjutnya simpan function yang sudah saya buat ini (mau di form atau di module, bebas) :
Public Function djieGetDataToImage(ByVal pData As Byte()) As Drawing.Image
Try
Dim imgConverter As New System.Drawing.ImageConverter()
Return TryCast(imgConverter.ConvertFrom(pData), Drawing.Image)
Catch ex As Exception
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
Return Nothing
End Try
End Function
Nah, ini implementasi pada saat datagridview di click :
Private Sub djieDataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles djieDataGridView1.CellClick
djiePictureBox1.Image = djieGetDataToImage(djieDataGridView1.CurrentRow.Cells(1).Value)
End Sub
Jika ingin menggunakan DataReader, artinya memilih photo-nya langsung dari table, seperti ini contoh implementasinya :
Private Sub djieDataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles djieDataGridView1.CellClick
Dim CMD As New Odbc.OdbcCommand("SELECT PHOTO FROM EMPLOYEES WHERE FIRSTNAME='" + djieDataGridView1.CurrentRow.Cells(0).Value.ToString + "'", CON)
Dim RD As Odbc.OdbcDataReader = CMD.ExecuteReader
If RD.Read Then
djiePictureBox1.Image = djieGetDataToImage(RD.Item("PHOTO"))
End If
RD.Close()
End Sub
Selamat mencoba, semoga sukses !
Tags:
Show image to picture box, datagridview to picturebox, picturebox from datagridview, set image from datagridview, set image from datareader, get image from datagridview, get image from datareader, datareader to picturebox, visual basic net, c#, visual studio, example, source code
