Radscheduler and binding data

1 posts, 0 answers
  1. AName
    AName avatar
    13 posts
    Member since:
    Jul 2013

    Posted 09 Dec 2013 Link to this post

    Hello there,

    due to some concerns I want to populate the radscheduler from a query I execute in the code behind and avoid using the sqldatasource within the .aspx.

    i have not found an example and all of my attempts have been unsuccessful, can you point me in the right direction?

    In esscence i want to execute a query against a view titled appointments and then bind the data as in the folllowing...

    can you get me to the next step?  sorry i new to the scheduler and trying to determine if all of this is possible.

    Protected Sub RadScheduler_OnLoad(ByVal sender As Object, ByVal e As EventArgs) Handles RadScheduler1.Load


    Dim myDBUtil As DBUtil.DBUtils = DirectCast(Me.Page, BasePage).reqDBUtils

    Dim rTable As DataTable = dbUtils.GetDataTable("SELECT [ID], [RoomID]+'%'+[Subject] + ' ' + [RoomID] as [Subject], [Start], [End],[RoomID], [UserID], [RecurrenceRule], [RecurrenceParentID] FROM [Appointments] WHERE [id] = @id", {{"@id", Session("user_id")}})

    End Sub

Back to Top