I'm trying to get values from DataGridView to the another form in textboxes and in Picturebox ,data in textboxes are there ok, but when I try to get a picture in a picturebox from DB it gives me this error.
Buffer cannot be null
Parameter name :buffer
and here is the code
Private Sub dgv1_CellDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DGV1.CellDoubleClick
Dim frm As New Edit_Employee()
frm.MdiParent = Mainfrm
frm.Show()
frm.TextBox1.Text = DGV1.Rows(e.RowIndex).Cells(1).Value.ToString
frm.TextBox2.Text = DGV1.CurrentRow.Cells(2).Value.ToString
frm.TextBox3.Text = DGV1.CurrentRow.Cells(3).Value.ToString
frm.TextBox4.Text = DGV1.CurrentRow.Cells(4).Value.ToString
frm.TextBox5.Text = DGV1.CurrentRow.Cells(5).Value.ToString
frm.TextBox6.Text = DGV1.CurrentRow.Cells(6).Value.ToString
frm.TextBox7.Text = DGV1.CurrentRow.Cells(7).Value.ToString
frm.TextBox8.Text = DGV1.CurrentRow.Cells(8).Value.ToString
frm.DateTimePicker1.Text = DGV1.CurrentRow.Cells(9).Value.ToString
frm.TextBox9.Text = DGV1.CurrentRow.Cells(10).Value.ToString
frm.TextBox10.Text = DGV1.CurrentRow.Cells(11).Value.ToString
frm.TextBox11.Text = DGV1.CurrentRow.Cells(12).Value.ToString
frm.TextBox12.Text = DGV1.CurrentRow.Cells(13).Value.ToString
frm.TextBox13.Text = DGV1.CurrentRow.Cells(14).Value.ToString
frm.TextBox14.Text = DGV1.CurrentRow.Cells(15).Value.ToString
frm.TextBox15.Text = DGV1.CurrentRow.Cells(16).Value.ToString
frm.DateTimePicker2.Text = DGV1.CurrentRow.Cells(17).Value.ToString
frm.DateTimePicker3.Text = DGV1.CurrentRow.Cells(18).Value.ToString
frm.TextBox16.Text = DGV1.CurrentRow.Cells(19).Value.ToString
frm.TextBox17.Text = DGV1.CurrentRow.Cells(20).Value.ToString
frm.TextBox18.Text = DGV1.CurrentRow.Cells(21).Value.ToString
frm.TextBox19.Text = DGV1.CurrentRow.Cells(22).Value.ToString
frm.Txtbonus.Text = DGV1.CurrentRow.Cells(23).Value.ToString
frm.TextBox21.Text = DGV1.CurrentRow.Cells(24).Value.ToString
Try
Dim connection As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
Dim command As New SqlCommand("SELECT Imagedata FROM Employee WHERE Firstname = '" & TextBox1.Text & "'", 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)
frm.PB1.Image = (picture)
End Using
Catch ex As Exception
MsgBox(ex.Message)
End Try
frm.Txtfilepath1.Text = DGV1.CurrentRow.Cells(27).Value.ToString
frm.Txtfilename.Text = DGV1.CurrentRow.Cells(26).Value.ToString
frm.TxtGross.Text = DGV1.CurrentRow.Cells(28).Value.ToString
frm.RTB1.Text = DGV1.CurrentRow.Cells(29).Value.ToString
End Sub