How to use Raschedule

1 posts, 0 answers
  1. Vuyiswa Maseko
    Vuyiswa Maseko avatar
    187 posts
    Member since:
    Jan 2010

    Posted 29 Apr 2010 Link to this post

    Good Day All

    i have the Following Query

    SELECT  distinct  ID, Dy,  Sess,[Code],[Description],Abrev,[Type],Number,

    and the table looks like this
    See Screenshot of the table

    In my timetable the data will look like this on a custom Schedule that i created myself , it consist of labels and more

    Old Viewer

    Now on the Lefthand Side you see there are Numbers 1,2,3, till 13. This is because no dates has been used. So i will be using the number of Periods a day. So this data will be comming from the Database and  at the top there are days excluding Sundays and Saturdays.

    Now i want to use the RadSchedule to Display the timetable

    By html looks like this

    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="New_Viewer.aspx.cs" Inherits="Viewer_New_Viewer" %>

    <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">

    <html xmlns="" >
    <head runat="server">
        <form id="form1" runat="server">
            <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
            <telerik:RadScheduler ID="RadScheduler1" runat="server" DataSourceID="SqlDataSourceTimetable"
                DataEndField="Date" DataKeyField="ID" Skin="Sunset" Height="726px" DataSubjectField="Description" DataStartField="Date" DataRecurrenceField="Dy" DataRecurrenceParentKeyField="Sess">
            <asp:SqlDataSource ID="SqlDataSourceTimetable" runat="server" ConnectionString="<%$ ConnectionStrings:oDirectConnectionString %>"
                OnSelecting="SqlDataSourceTimetable_Selecting" ProviderName="<%$ ConnectionStrings:DBConnectionString.ProviderName %>"
                SelectCommand="sp_Timetable_View" SelectCommandType="StoredProcedure">
                    <asp:Parameter Name="selectionType" Type="String" />
                    <asp:SessionParameter Name="selectedItems" SessionField="selectedItems" Type="String" />
                    <asp:SessionParameter Name="selectedTerms" SessionField="selectedTerms" Type="String" />

    and now i am using the Stored Procedure to get Data and i tested the sp in SQL management studio with its parameters and it brought the data back.

    and this is how i used it with the Radschedule and i don't get any appointments when i run the application. in the Server on page load i have add this

        protected void Page_Load(object sender, EventArgs e)

    and still it does not work.


Back to Top