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