This is a migrated thread and some comments may be shown as answers.

Passing Parameters to Stored Procedure

1 Answer 543 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Eric Turner
Top achievements
Rank 1
Eric Turner asked on 04 Mar 2009, 01:28 AM
I have a Telerik Report and want to bind data to the report by using a stored procedure.  I can accomplish that easily with a select statement or calling a stored proc that has no parameters.  When I try passing a parameter I get the message "The EXEC SQL construct or statement is not supported". 

I defined a report parameter called @UserID and call the stored proc like this: EXEC get_data @UserID.  This appears to be inline with the sample syntax shown at the bottom of the wizard when I am creating the connection (SELECT ColumnName1, ColumnName2 FROM TableName WHERE ColumnName1 = @ParameterName). I can even call the procedure with a hard coded value and it works like so: EXEC get_data 'myparm'.    

Thanks for any help

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 04 Mar 2009, 02:50 PM
Hi Eric,

You might find the following forum thread helpful. Please review it along with the links to articles and KB included and let us know if further help is needed.

Regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
General Discussions
Asked by
Eric Turner
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or