Scheduler execute_sql passing incorrect syntax

[zx10r]

I have a scheduler setup where the datasource select command also has a control parameter being passed in from a combo box. The generated execute_sql statement does not seem to work and sql server complains about parameter not being passed in. I have tried executing the generated statement manually in sql server and the result is the same. The code is bellow:

 

SelectCommand="EXEC Scheduler.GetAppointments" 

 <SelectParameters>
            <asp:ControlParameter ControlID="cmbProviderSort" DbType="Int32" ConvertEmptyStringToNull="true" DefaultValue="-1" 
                PropertyName="SelectedValue" Name="a" />
        </SelectParameters>

 

The generated statement from this is : exec sp_executesql N'EXEC Scheduler.GetAppointments',N'@a int',@a=26

If i try and execute that statement on sql server it complains the @a parameter is not being passed.

Thanks

[zx10r]

The issue was not specifying using the stored procedure statement type inside the data source.

[Eyup]

Hello,

I am glad that you've managed to pinpoint the cause of the issue.
Please note that this is a generic requirement not related to Telerik specifically. You can check various sources over the net about ControlParameters and Stored Procedures:
https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.controlparameter(v=vs.110).aspx
http://stackoverflow.com/questions/5326113/how-to-specify-parameter-value-for-stored-procedure-in-sqldatasource

If you have any questions related to the functionality of Telerik controls, please do not hesitate to contact us.

Regards,
Eyup
Telerik by Progress