Question Mark As Query Parameter?

I have stumbled upon a DataSource sample at http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.querystringparameter(v=vs.100).aspx The code is as follows <%@Page

Solution 1:

Some database systems use anonymous parameters, usually signalled by a ?. You then have to provide the parameters in the correct sequence.

Other systems use named parameters. SqlServer uses a @name syntax. You could then provide the parameters out of order, because they are matched on name instead of position.

Change that WHERE EmployeeID=? into WHERE EmployeeID=@empId to match the name of your parameter.

Solution 2:

The three parameters should be replaced with

EmployeeID = @empId
ShippedDate = @date
OrderID = @ordered

MSDN's samples sometimes don't work.