I'm using the DataAdapter Fill method, which uses the ExecuteReader method.

>What command do you execute? Do you have
>
>

>OleDbReader myReader = objCmd.ExecuteReader();
>

>
>Or you use another command?
>
>>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?