or



| SELECT A.ID AS apptID, U.userID, A.name, A.[dateTime], A.dateTimeEnd, U.userName<br> |
| FROM AppointmentUsers AXU<br> |
| JOIN Users U ON AXU.userID = U.userID<br> |
| JOIN Appointments A ON AXU.apptID = A.ID |
| <telerik:RadScheduler ID="Scheduler" |
| DataKeyField="apptID" |
| DataSubjectField="name" |
| DataStartField="dateTime" |
| DataEndField="dateTimeEnd" |
| DataSourceID="AppointmentsData" |
| runat="server"> |
| <DayView ShowResourceHeaders="true" /> |
| <WeekView ShowResourceHeaders="true" /> |
| <MonthView ShowResourceHeaders="true" /> |
| <TimelineView ShowResourceHeaders="true" /> |
| <ResourceTypes> |
| <telerik:ResourceType Name="Tech" KeyField="userID" ForeignKeyField="apptID" TextField="userName" DataSourceID="AppointmentsData" /> |
| </ResourceTypes> |
| </telerik:RadScheduler> |
| <asp:SqlDataSource ID="AppointmentsData" |
| ProviderName="System.Data.SqlClient" |
| ConnectionString=xxx |
| SelectCommand="SELECT A.ID AS apptID, U.userID, A.name, A.[dateTime], A.dateTimeEnd, U.userName |
| FROM AppointmentUsers AXU |
| JOIN Users U ON AXU.userID = U.userID |
| JOIN Appointments A ON AAXU.apptID = A.ID |
| WHERE A.companyID = 7673" |
| runat="server" /> |
| <telerik:RadGrid ID="grdBookings" runat="server" AutoGenerateColumns="false" Skin="Office2007" |
| OnNeedDataSource="grdBookings_NeedDataSource" OnItemDataBound="grdBookings_ItemDataBound" |
| AllowSorting="true" Width="99%" AllowPaging="true" PagerStyle-Mode="NextPrevAndNumeric" |
| EnableEmbeddedSkins="true"></telerik:RadGrid> |
| -------------- |
| <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxyViewBooking" runat="server"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="ddlBookings"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="grdBookings" LoadingPanelID="RadAjaxLoadingPanel2" /> |
| <telerik:AjaxUpdatedControl ControlID="ddlBookings" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="grdBookings"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="grdBookings" LoadingPanelID="RadAjaxLoadingPanel2" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManagerProxy> |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel2" runat="server" Skin="Default"> |
| </telerik:RadAjaxLoadingPanel> |
| <%@ Page Language="C#" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <script runat="server"> |
| protected void RadDatePicker1_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e) { |
| Label1.Text = RadDatePicker1.SelectedDate.ToString(); |
| } |
| </script> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head runat="server"> |
| <title></title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <asp:ScriptManager ID="ScriptManager1" runat="server"> |
| </asp:ScriptManager> |
| <div> |
| <p> |
| <telerik:RadDatePicker ID="RadDatePicker1" runat="server" AutoPostBack="True" OnSelectedDateChanged="RadDatePicker1_SelectedDateChanged"> |
| <DateInput AutoPostBack="True"> |
| </DateInput> |
| <Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x"> |
| </Calendar> |
| <DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton> |
| </telerik:RadDatePicker> |
| <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></p> |
| <p> |
| </div> |
| </form> |
| </body> |
| </html> |
| <?xml version="1.0" encoding="utf-8" ?> |
| <configuration> |
| <property name="Skin">Default</property> |
| <property name="NewLineBr">false</property> |
| <property name="Width">600</property> |
| </configuration> |
