Try replacing @SelectUser with ?. Otherwise I can't see anything wrong with your code.
Since OleDb parameters (which I'm sure that he's using [:D] ) are not recognized by their name, chancing the parameter name will not solve anything!
"no value found for one or more needed parameters". This error ussualy occurs when a fieldname (or tablename) in the SQL string is misspelled. Access (or better said Jet) will thread this misspelled (not existing) fieldname as a parameter. If you've access
on you computer, try to run the SQL statement in Access. Access will prompt you for every non existing fieldname, I think it will not only prompt you for the parameter @SelectUser but also for 1 or more other misspelled fieldnames....
All-Star
25756 Points
7014 Posts
Re: Submitting session parameters into a select command on a asp.datasource
Jun 11, 2009 10:09 PM|hans_v|LINK
Since OleDb parameters (which I'm sure that he's using [:D] ) are not recognized by their name, chancing the parameter name will not solve anything!
"no value found for one or more needed parameters". This error ussualy occurs when a fieldname (or tablename) in the SQL string is misspelled. Access (or better said Jet) will thread this misspelled (not existing) fieldname as a parameter. If you've access on you computer, try to run the SQL statement in Access. Access will prompt you for every non existing fieldname, I think it will not only prompt you for the parameter @SelectUser but also for 1 or more other misspelled fieldnames....