I am following the example for resource availability but I can't figure out how to store additional text fields (Phone, BookedBy) for the appointments. I don't need them as drop down selectable resources, I need simple text entry. Is there a way to do this?
Here is my sql data:
<asp:SqlDataSource ID="AppointmentsDataSource" runat="server" ProviderName="System.Data.SqlClient"
ConnectionString="<%$ ConnectionStrings:MCHPEVENTS %>" SelectCommand="SELECT [SchedulingID], [Start], [End], [Subject], [BookedBy], [Phone], [RoomID] FROM [RS_Scheduling]"
InsertCommand="INSERT INTO [RS_Scheduling] ([Start], [End], [Subject], [RoomID], [BookedBy], [Phone]) VALUES (@Start, @End, @Subject, @RoomID, @BookedBy, @Phone)"
UpdateCommand="UPDATE [RS_Scheduling] SET [Start] = @Start, [End] = @End, [Subject] = @Subject, [RoomID] = @RoomID, [BookedBy] = @BookedBy, [Phone] = @Phone WHERE (SchedulingID = @SchedulingID)"
DeleteCommand="DELETE FROM [RS_Scheduling] WHERE [SchedulingID] = @SchedulingID">
<DeleteParameters>
<asp:Parameter Name="SchedulingID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="SchedulingID" Type="Int32" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="BookedBy" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="BookedBy" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
Thanks
http://demos.telerik.com/aspnet-ajax/scheduler/examples/resourceavailability/defaultvb.aspx
Here is my sql data:
<asp:SqlDataSource ID="AppointmentsDataSource" runat="server" ProviderName="System.Data.SqlClient"
ConnectionString="<%$ ConnectionStrings:MCHPEVENTS %>" SelectCommand="SELECT [SchedulingID], [Start], [End], [Subject], [BookedBy], [Phone], [RoomID] FROM [RS_Scheduling]"
InsertCommand="INSERT INTO [RS_Scheduling] ([Start], [End], [Subject], [RoomID], [BookedBy], [Phone]) VALUES (@Start, @End, @Subject, @RoomID, @BookedBy, @Phone)"
UpdateCommand="UPDATE [RS_Scheduling] SET [Start] = @Start, [End] = @End, [Subject] = @Subject, [RoomID] = @RoomID, [BookedBy] = @BookedBy, [Phone] = @Phone WHERE (SchedulingID = @SchedulingID)"
DeleteCommand="DELETE FROM [RS_Scheduling] WHERE [SchedulingID] = @SchedulingID">
<DeleteParameters>
<asp:Parameter Name="SchedulingID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="SchedulingID" Type="Int32" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="BookedBy" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="BookedBy" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
Thanks
http://demos.telerik.com/aspnet-ajax/scheduler/examples/resourceavailability/defaultvb.aspx