Hi Dan,

Have you tried this?

objCmd.Parameters.Add("CustomerID", OleDbType.VarChar).Value = "ALFKI"

These documentation links might help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbParameterPropertiesTopic.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbParameterCollectionClassAddTopic.asp

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