Looks like the oleDbDataAdapter cannot create parameterized queries with VFP table. However, looks like it does work with Access data, etc...

The way I found to do this was:

oleDbDataAdapter1.SelectCommand.CommandText = "Select * from employee " +
"where employee.lastname = '" + lc_search + "' order by lastname";

dsEmpLast1.Clear();
oleDbDataAdapter1.Fill(dsEmpLast1);

Thanks

Jerry


>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