Hi Jerry,

Take a look of the thread Id #703020
it probable answer you...

Rock


>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