RadScheduler StoredProcedure Dates

2 posts, 0 answers
  1. Richard
    Richard avatar
    20 posts
    Member since:
    Sep 2010

    Posted 18 May 2011 Link to this post

    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!
  2. Richard
    Richard avatar
    20 posts
    Member since:
    Sep 2010

    Posted 19 May 2011 Link to this post

    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.

Back to Top