Dynamic Resource

[SSirica]

I have a scheduler with appointments where the resource is dependant on an aspect of the appointment.  Here is the scenario.  There are work tickets that have been assigned to different groups.  Each group has a sub set of members that it can be assigned to, essentially setting up a situation where the Resource ("Members") is dependant upon the associated action ticket Group ID.  Gettting the data is not the issue, and the "how" off adding a dynamic resource is also not the issue, what I need to know is where to put:

Dim rt As New Telerik.Web.UI.ResourceType
rt.DataSource = ds
rt.Name = "Members"
rt.ForeignKeyField = "user_id"
rt.KeyField = "user_id"
rt.TextField = "user_first"
rsWorkSch.ResourceTypes.Add(rt)

So far I've tried: .AppointmentClick, .FormCreating and .FormCreated.  In every instance the drop down is empty. 

My question is...where do I put the code to add a dynamic resource so the drop down actually contains data?

[Veronica]

Hello SSirica,

You need to put the code in the OnDataBound event so the resources will be added.

Please let me know if you have more questions.

All the best,
Veronica Milcheva
the Telerik team

[Craig Finnigan]

Can you provide a example of what gets added to the ondatabound event?

[Veronica]

Hi Craig Finnigan,

Please accept my apologies for misleading you.

It will be too late to add resources in the OnDataBound event. The most proper is Page_Init. Here's a sample code:

protected void Page_Init(object sender, EventArgs e)
    {
        ResourceType rt = new ResourceType();
        rt.DataSource = RoomsDataSource;
        rt.Name = "Room";
        rt.ForeignKeyField = "RoomID";
        rt.KeyField = "ID";
        rt.TextField = "RoomName";
        RadScheduler1.ResourceTypes.Add(rt);
    }

ASPX:

<telerik:RadScheduler ID="RadScheduler1" runat="server" OnDataBound="RadScheduler1_DataBound"
        DataDescriptionField="Description" DataEndField="End" DataKeyField="ID" DataRecurrenceField="RecurrenceRule"
        DataRecurrenceParentKeyField="RecurrenceParentID" DataReminderField="Reminder"
        DataSourceID="SqlDataSource1" DataStartField="Start" DataSubjectField="Subject"
        EnableDescriptionField="True">
        <Reminders Enabled="True" />
        </ResourceTypes>
    </telerik:RadScheduler>
    <asp:SqlDataSource ID="RoomsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"
        SelectCommand="SELECT * FROM [Rooms]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT * FROM [Appointments]"></asp:SqlDataSource>

Hope this helps.

Best wishes,
Veronica Milcheva
the Telerik team