I'm using C# to create a WinForm to display a VFP table. I want the user to enter in a employee's last name and have the form look up that employee record from employee.dbf.

I create an oleDbDataAdapter on the form and connect to a free VFP table. I build a SQL command as follows:

SELECT * FROM employee WHERE (lastname = ?)

My problem is that when I attempt to generate a DataSet, I get the following error message:

Retrieving the schema for oleDbDataAdpater1 failed. No value given for one or more required parameters.

How can I create a parameterized query in C#? Or what am I doing wrong?

Thanks,

Jerryt