sqlDataSource and parameters

[Tomas]

Hello,

I use sqlDataSource and SelectQuery property to retriev data from access
database.
There is some problems with SelectQuery and Parameters.

I have sql below in sqlDataSource.SelectQuery and parameter as Name = ?
Value = title
Every time I start application I get error "SQL parsing error - Invalid
expression ? found in SELECT SQL statement at line 3"

Can someone point me what is wrong?


Select item.*, category.title as CategoryTitle, category.code as
CategoryCode
from item Join category On item.categoryid=category.id
Order By ?



regards,
Tomas

 

[Mary Chipman [MSFT]]

SqlClient uses named parameters, not positional parameters like OleDb.
Here's a link to the help topic describing parameters and parameter
placeholders: http://msdn.microsoft.com/en-us/library/yy6y35y8.aspx

--Mary