I have a radscheduler component on an asp.net page - connected to a sql server data source. I have stored procedures for the select, add, update and delete procedures.
On the 'select' stored procedure, if I DON'T set the default values for the begin and end dates, the stored procedure doesn't select any records. How can I check the 'dates' that the radscheduler is displaying and then submit those dates to the 'select' stored procedure? (Obvously, the select stored procedures requires a date range)
Thanks!
On the 'select' stored procedure, if I DON'T set the default values for the begin and end dates, the stored procedure doesn't select any records. How can I check the 'dates' that the radscheduler is displaying and then submit those dates to the 'select' stored procedure? (Obvously, the select stored procedures requires a date range)
Thanks!
1 Answer, 1 is accepted
0
Richard
Top achievements
Rank 1
Rank 1
answered on 19 May 2011, 03:26 PM
Never mind... I found it.
On the SqlDataSource1_Selecting event,
RadScheduler1.VisibleRangeStart
RadScheduler1.VisibleRangeEnd
The two properties will return the start and end dates of the current view on the RadScheduler. I pass these values to the stored procedure parameters for begin and end dates and my data comes back every time.
Thanks.