I've tried all combinations of adding the parameter. Nothing seems to work...

>Hi Dan,
>
>This works in VFP. Maybe you can translate it into ASP.NET?

oCmd.CommandText = [select * from customers where CustomerID = ?]
>oPar = oCmd.CreateParameter("CustomerID", adVarChar, adParamInput, 6, "ALFKI")
>oCmd.Parameters.Append(oPar)
>oRs = oCmd.Execute()

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