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

[Solved] Scheduler and vb datasource

2 Answers 156 Views

Scheduler

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

Mark asked on 25 Apr 2008, 01:12 PM

Hi,
I'm struggling a bit to select, update, delete my scheduler from SQL database.
I want to create my datasource from within the vb code file, not like this...(see bottom)
I have looked at you dbproviders but not had much joy (as in c).
I have a RadWindow that i would like to enable the user to change the scheduler layout (resources visible etc.), so this is why i am trying to create datasource.

Can you please help me ?
Thanks
Mark

<telerik:RadScheduler ID="RadScheduler1" runat="server"

DataEndField="EndDateTime" DataKeyField="SchedulerTaskID"

DataSourceID="EventsDataSource" DataStartField="StartDateTime"

DataSubjectField="JobDescription" DayEndTime="19:00:00" DayStartTime="08:00:00"

EnableEmbeddedSkins="True" GroupBy="Resource" GroupingDirection="Horizontal"

Height="450px" SelectedDate="2008-05-30" SelectedView="DayView" Skin="Sunset"

TimeZoneOffset="03:00:00" Width="1000px">

<telerik:ResourceType DataSourceID="ResourceDataSource"

ForeignKeyField="ResourceName" KeyField="ResourceName" Name="Resource"

TextField="ResourceName" />

</ResourceTypes>

</telerik:RadScheduler>

<asp:SqlDataSource ID="EventsDataSource" runat="server"

ConnectionString="<%$ ConnectionStrings:myConnectionString %>"

SelectCommand="SELECT Clerk as ResourceName, [SchedulerTaskID], [JobDescription], [StartDateTime], [EndDateTime] FROM [SchedulerEvent]">

</asp:SqlDataSource>

<asp:SqlDataSource ID="ResourceDataSource" runat="server"

ConnectionString="<%$ ConnectionStrings:myConnectionString %>"

SelectCommand="SELECT ResourceName FROM Calendar_Resource">

</asp:SqlDataSource>

[Solved] Scheduler and vb datasource

2 Answers, 1 is accepted