No value given for one or more required parameters.

I got the above error message when I try to run my program with the folowing code:

varEmployeeNo =Me.Employee_masterTableAdapter.GetData.Rows(0).Item(0).ToString()

SELECT employee_number, employee_firstname, employee_lastname, employee_sex
FROM employee_master WHERE employee_lastname = lname

but when I try to hardcode my SQL like this:

SELECT employee_number, employee_firstname, employee_lastname, employee_sex
FROM employee_master WHERE employee_lastname = "PERALTA"

my program works .

I wonder if you can help me with this.

[722 byte] By [fmar] at [2008-1-3]