TableAdapter configuration wizard and QueryBuilder give confusing error messages when SQL parameters are used in a query.
If you don't declare a parameter in your SQL statement, the wizard tells that
Must declare the scalar variable @Parameter
On the other hand, if you put in a declare statement and open QueryBuilder, it gives you a syntax error:
The Declare SQL construct or statement is not supported
I don't know if this is something you guys can do anything about. You can get through the wizard by adding a parameter declaration and that's about it.
The real problem is that in order to get the report working, you have to manually remove the parameter from the DataSet designer file and add it to the DataSetTableAdapter Fill function. Otherwise, the report does not run.
Or is there a way to use TableAdapter wizard with SQL paremeters without touching the designer files?
-mika-