SQL Parameters in TableAdapter

[Mika]

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-

[Steve]

Hi Mika,

Please review the following forum thread for more info on the problem.

Sincerely yours,
Steve
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.