ado troubles with vb.net 2003

[Rubber Steve]

I am having trouble querying an Access database with ADO .NET in VB .NET. I
can get results returned using primary keys, but when using something like
LastName, nothing happens. I am not sure why this is. Here is the query
that works, and the one that doesn't:

Works:
cmd = New OleDbCommand("select * from employee where EmployeeID= " &
txtEmployeeID.Text, cn)

Does Not Work:
cmd = New OleDbCommand("select * from employee where EmpLastName like " &
txtLast.Text, cn)

Any help would be greatly appreciated,

Rubber Steve

 

[pierrick-allusse]

Do this :

cmd = New OleDbCommand("select * from employee where EmpLastName like '%" +
txtLast.Text + "%'", cn)

And try...^^ Don't forget the single quote !

Pierrick

 

[Rubber Steve]

Do this :

cmd = New OleDbCommand("select * from employee where EmpLastName like '%" +
txtLast.Text + "%'", cn)

And try...^^ Don't forget the single quote !

Thank you. You were most helpful!

Rubber Steve