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?