hi
i have a database with a image(Binarycode)
and i want to select that image and infomation
i tryed like this but it says liki this
OledbExpaession unhandled
No value given for one or more required parameters.
my code like this
Imports System.Configuration
Public Class Form9
Dim A As String = ConfigurationSettings.AppSettings("Datapath")
Dim con1 As New OleDb.OleDbConnection(A)
Dim com1 As OleDb.OleDbCommand
Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click
con1.Open()
com1 = New OleDb.OleDbCommand("Select * from Employee where EId="+MaskedTextBox6.Text+"",con1)
Dim rd As OleDb.OleDbDataReader
rd = com1.ExecuteReader()
If rd.Read = True Then
ECODEMasked1.Text = rd.GetValue(0)
MaskedTextBox5.Text = rd.GetValue(1)
TextBox3.Text = rd.GetValue(2)
TextBox4.Text = rd.GetValue(3)
TextBox5.Text = rd.GetValue(4)
TextBox6.Text = rd.GetValue(5)
TextBox7.Text = rd.GetValue(6)
TextBox8.Text = rd.GetValue(7)
ENICMasked3.Text = rd.GetValue(8)
DateTimePicker1.Value = rd.GetValue(9)
ComboBox3.SelectedItem = rd.GetValue(10)
ETeleMasked2.Text = rd.GetValue(11)
TextBox10.Text = rd.GetValue(12)
PictureBox1.Image = rd.GetValue(13)
Else
MsgBox("Record not Found", MsgBoxStyle.Information, "Search")
End If
con1.Close()
End Sub
End Class