dataType mismatch with the criteria

[as7685]

Hi folks.,
i using windows application of .net with Vb as its language and
backend as ms access

i am using a query as like this

cn.Open()
cmd = New OleDbCommand("select * from Employee where EmpNo ='" & TextBox14.Text & "'", cn)
dr = cmd.ExecuteReader()
While dr.Read()
TextBox13.Text = dr("name")
End While

i am getting an error as dataType mismatch with the criteria..

here EmpNo is Number DataType .. any clues folks..

 

[rainman89]

("select * from Employee where EmpNo = "& TextBox14.Text, cn)