I get

No value give for one or more parameters.

>One other thing. Try changing your command to the following syntax:
>
>

>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = (?)");
>objCmd.Parameters.Add("@myParam", "ALFKI");
>

>
>Note that you don't need the "myParam" in the SQL Select.
>
>HTH.
>
>>I tried:
>>

>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?myParam");
>>objCmd.Parameters.Add("@myParam", "ALFKI");
>>

>>
>>gives me
>>
>>

>>Command contains unrecognized phrase/keyword.
>>

>>
>>and
>>
>>

>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?myParam");
>>objCmd.Parameters.Add("@myParam", "ALFKI");
>>

>>
>>gives me
>>
>>

>>Missing operand.
>>

>>>I think you are missing "@" in your syntax. I think it should be
>>>
>>>

>>>objCmd.Parameters.Add("@CustomerID", "ALFKI");
>>>

>>>
>>>HTH.
>>>
>>>>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?