When I execute it this way am getting an OleDbException that says:
No value given for one or more required parameters.
>Dan,
>
>I'm not 100% sure (since I'm not using the VFPOLEDB provider), but I think the "@" sign, as Dmitry suggested, is for SQL. I think you need to use the "?" for OleDB. Try this instead:
>
>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?");
>objCmd.Parameters.Add("?CustomerID", "ALFKI");
>
>
>~~Bonnie
>
>
>>I'm using the VFPOLEDB provider and I am creating a command object like this:
>>
>>
>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?");
>>objCmd.Parameters.Add("CustomerID", "ALFKI");
>>
>>
>>When I execute this command I am getting an OleDbException that says:
>>
>>
>>No value given for one or more required parameters.
>>
>>
>>How do I use the parameter collection to pass parementers to commands?