RadScheduler not passing data to db

[Yann]

Hi

I am using Radscheduler and an underlying data base to manage site visits.

I have set my datasource as followed:
On insert there is a line created in the table (with auto ID) but no value for the other fields.
Also, when I try to move an appointment, it goes back where is was before.
So it seems that the fields are not passing to the database for some reason
Thanks for your help
Regards

<asp:SqlDataSource ID="SchedulerDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:TEST_DS%>"

 

ProviderName="System.Data.SqlClient"

 

SelectCommand="SELECT [SiteVisitID], [SiteVisitStart], [SiteVisitEnd], [SiteVisitSubject], [SiteVisitDue], [SiteVisitPriority] FROM [tbl_SiteVisit] WHERE ([SiteVisitStart] IS NOT NULL) AND ([SiteVisitEnd] IS NOT NULL)"

 

InsertCommand="INSERT INTO [tbl_SiteVisit] ([SiteVisitSubject], [SiteVisitStart], [SiteVisitEnd]) VALUES (@Subject, @Start, @End)"

 

UpdateCommand="UPDATE [tbl_SiteVisit] SET [SiteVisitStart] = @Start, [SiteVisitEnd] = @End, [SiteVisitSubject] = @Subject WHERE SiteVisitID = @ID"

 

DeleteCommand="DELETE FROM [tbl_SiteVisit] WHERE [SiteVisitID] = @ID">

 

<insertparameters>

 

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

 

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

 

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

 

</insertparameters>

 

<updateparameters>

 

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

 

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

 

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

 

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

 

</updateparameters>

 

<deleteparameters>

 

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

 

</deleteparameters>

 

</asp:SqlDataSource>

[Peter]

Hi Yann,

Can you also send us your RadScheduler declaration and any related code behind you might have? The information you provide so far is not sufficient to determine the cause of the problem.


Best wishes,
Peter
the Telerik team