[Solved] Resource not binding on edit

[Rick]

Here is the rad scheduler and the data sources, I get the resources to enter into the db however when I go back to edit them They do not bind the dropdown anymore. Can someone explain what else is needed to get that to happen? <telerik:radscheduler runat="server"  Width="797px" SelectedView="MonthView" id="appointmentScheduler"

Height="565px" DataEndField="End" DataKeyField="appointmentId" DataSourceID="SqlDataSource1"

DataStartField="Start" DataSubjectField="subject" Skin="WebBlue"

StartInsertingInAdvancedForm="True" OnAppointmentDataBound="appointmentBound">

<resourcetypes>

<telerik:ResourceType DataSourceID="SqlDataSource3" ForeignKeyField="typeId"

KeyField="appointmentTypeId" Name="Type" TextField="type" />

</resourcetypes>

</telerik:radscheduler>

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

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

SelectCommand="SELECT [appointmentTypeId], [type] FROM [v2AppointmentTypes] ORDER BY [type]">

</asp:SqlDataSource>

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

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

SelectCommand="SELECT * FROM [v2Appointment]"

DeleteCommand="DELETE FROM [v2Appointment] WHERE [appointmentId] = @appointmentId"

InsertCommand="INSERT INTO [v2Appointment] ([typeId], [Start], [End], [subject]) VALUES  (@typeId, @Start, @End, @subject)"

UpdateCommand="UPDATE [v2Appointment] SET [typeId] = @typeId, [Start] = @Start, [End] = @End,  [subject] = @subject WHERE [appointmentId] = @appointmentId">

<DeleteParameters>

<asp:Parameter Name="appointmentId" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="typeId" Type="String" />

<asp:Parameter Name="Start" Type="DateTime" />

<asp:Parameter Name="End" Type="DateTime" />

<asp:Parameter Name="subject" Type="String" />

<asp:Parameter Name="appointmentId" Type="Int32" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="typeId" Type="String" />

<asp:Parameter Name="Start" Type="DateTime" />

<asp:Parameter Name="End" Type="DateTime" />

<asp:Parameter Name="subject" Type="String" />

</InsertParameters>

</asp:SqlDataSource>

[Rick]

Really??? no one?

It seems odd that not one person would have any idea why this is happening.

[Veselin Vasilev]

Hi mystrymaster,

I could not reproduce the problem in our online demo.
Can you use it as a base and create a simple project that demonstrates the issue?
You can attach it in another support ticket.

Greetings,
Veselin Vasilev
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[Rick]

It wasn't until I tried to set up a sample project to send off that I noticed the problem.

The typeId field in the appointment table field was set as a varchar even though it was just housing the 1,2, 3, 4 or 5 of the appointment type it was not a match, adjusting the field to the int datatype it worked perfectly.