Please N'lander,

questn 1: i'm trying to search for record in my Database usiing vb.net OLedb , but it's complaining of [b]datatype mismatch in criterial expression [/b]at line
no 10 & 11

questn 1: At line no 18, how can i load picture of the person i'M searching for back on my picturebox from database?


1 Dim sqlstr As String, inp As String
2. strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
3 "Data Source=C:\Users\Ademola\Desktop\Oledb Connection\coop.mdb"
4 objConnection = New OleDbConnection(strConnection)
5 objConnection.Open()

6 inp = InputBox("Enter Oracle No"
7 sqlstr = "Select * from reg Where oracle='" & inp & "'"
8 objCmd.CommandText = sqlstr
9 objCmd.Connection = objConnection
10 dr = objCmd.ExecuteReader
11 dr.Read()
12 txtoracle.Text = dr.GetString(0)
13 txtmrn.Text = dr.GetString(1)
14 txtname.Text = dr.GetString(2)
15 txtha.Text = dr.GetString(3)
16 dp1.Text = dr.GetString(4)
17 cmbsex.Text = dr.GetString(5)
18 ' pic.Image = (dr.GetString(7))
19 dr.Close()


End Sub

Seems your datatype is causing the error, whats the datatype of the picture on your database