This is a migrated thread and some comments may be shown as answers.

Radscheduler and binding data

0 Answers 14 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
AName
Top achievements
Rank 1
AName asked on 09 Dec 2013, 09:49 PM

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





No answers yet. Maybe you can help?

Tags
Scheduler
Asked by
AName
Top achievements
Rank 1
Share this question
or