or



| protected void viewBookings_OnNeedDataSource(...) |
| { |
| string s_query = "select distinct bk.Start, fi.FacilityName, bk.Username " + |
| "from Booking_Form as bk, " + |
| "Facility_Item as fi " + |
| "where bk.FacilityID = fi.ID"; |
| IEnumerable<DisplayComponent> results = data.ExecuteQuery<DisplayComponent>(s_query); |
| viewBookingsGrid.DataSource = results.ToList(); |
| } |
| public class DisplayComponent |
| { |
| public string FacilityName, Username; |
| DateTime Start; |
| public DisplayComponent() |
| { |
| } |
| } |

Hello Sir
| <telerik:RadComboBox ID="ddl_Stores" AutoPostBack="true" runat="server" Visible="false" Width="100px" Skin="Forest" /> |
| <telerik:RadComboBox ID="ddl_Departments" AutoPostBack="true" runat="server" Visible="false" Width="200px" Skin="Forest"/> |
| <telerik:RadComboBox ID="ddl_Paging1" AutoPostBack="true" runat="server" Visible="false" Width="100px" Skin="Forest"/><br /><br /> |
| telerik:AjaxSetting AjaxControlID="ddl_Stores"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="ddl_Paging1" /> |
| <telerik:AjaxUpdatedControl ControlID="tbl_Data" LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="PivotTable" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Report.aspx.vb" Inherits="Report" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head id="Head1" runat="server"> |
| <title>Sales Report</title> |
| <script type="text/javascript" src="FusionCharts/FusionCharts.js"></script> |
| <script type="text/javascript"> |
| function RequestStart(sender, eventArgs) |
| { |
| var divElementStyle = document.getElementById("RadAjaxLoadingPanel1").style; |
| divElementStyle.position = 'absolute'; |
| //position the loading panel |
| divElementStyle.left = eventArgs.get_eventTargetElement().offsetLeft + "px"; |
| divElementStyle.top = eventArgs.get_eventTargetElement().offsetTop + "px"; |
| } |
| </script> |
| <style type="text/css"> |
| .CustomCssClass1 .rspPaneTabText, .rspPane, .RadSplitter |
| { |
| color: white !important; |
| border-color: white !important; |
| } |
| .CustomCssClass2 .rspSlideTitle |
| { |
| color: white !important; |
| } |
| </style> |
| </head> |
| <body style="background-color:#3d766f;; font-family:Verdana; font-size:12px;"> |
| <form id="form1" runat="server"> |
| <telerik:radscriptmanager id="RadScriptManager1" runat="server" AsyncPostBackTimeout="0" /> |
| <telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" Skin="Office2007" DecoratedControls="All" /> |
| <telerik:radajaxmanager id="RadAjaxManager1" runat="server" EnableEmbeddedScripts="true"> |
| <ClientEvents OnRequestStart="RequestStart" /> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="ddl_Stores"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="ddl_Paging1" /> |
| <telerik:AjaxUpdatedControl ControlID="tbl_Data" LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="PivotTable" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="ddl_Departments"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="ddl_Paging1" /> |
| <telerik:AjaxUpdatedControl ControlID="tbl_Data" LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="PivotTable" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| <telerik:AjaxSetting AjaxControlID="ddl_Paging1"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="ddl_Paging1" /> |
| <telerik:AjaxUpdatedControl ControlID="tbl_Data" LoadingPanelID="RadAjaxLoadingPanel1" /> |
| <telerik:AjaxUpdatedControl ControlID="PivotTable" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:radajaxmanager> |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" > |
| <img alt="Loading..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading.gif") %>' style="border:0;" /> |
| </telerik:RadAjaxLoadingPanel> |
| <asp:Table ID="tbl_Report" runat="server" BorderWidth="1px" cellpadding="5" cellspacing="0" width="100%" HorizontalAlign="center" height="100%" BackColor="#ffffff"> |
| <asp:TableRow> |
| <asp:TableCell ColumnSpan="2"><asp:Label ID="lb_Error" runat="server" Font-Bold="true" ForeColor="red" /></asp:TableCell> |
| </asp:TableRow> |
| <asp:TableRow> |
| <asp:TableCell VerticalAlign="top" ColumnSpan="2" Width="100%" Height="100%" BackColor="white"> |
| <telerik:RadSplitter id="RadSplitter1" runat="server" CssClass="CustomCssClass1" Skin="Forest" Width="100%" Height="23px" visible="false"> |
| <telerik:RadPane runat="server" id="RadPane1" Width="100%" > |
| <telerik:RadSlidingZone runat="server" ID="RadSlidingZone_Graph" SlideDirection="Bottom"> |
| <telerik:RadSlidingPane id="RadSlidingPane_Graph" title="Graph" runat="server" Scrolling="both"> |
| <telerik:RadComboBox ID="ddlcharttype" Font-Size="12px" runat="server" Skin="Forest" AutoPostBack="true"> |
| <Items> |
| <telerik:RadComboBoxItem Text="Select a chart type" Value="" /> |
| <telerik:RadComboBoxItem Text="Area" Value="Area" /> |
| <telerik:RadComboBoxItem Text="Bar" Value="Bar" /> |
| <telerik:RadComboBoxItem Text="Column" Value="Column" /> |
| <telerik:RadComboBoxItem Text="Line" Value="Line" /> |
| </Items> |
| </telerik:RadComboBox> |
| </telerik:RadSlidingPane> |
| </telerik:RadSlidingZone> |
| </telerik:RadPane> |
| </telerik:RadSplitter> |
| <telerik:RadComboBox ID="ddl_Stores" AutoPostBack="true" runat="server" Visible="false" Width="100px" Skin="Forest" /> |
| <telerik:RadComboBox ID="ddl_Departments" AutoPostBack="true" runat="server" Visible="false" Width="200px" Skin="Forest"/> |
| <telerik:RadComboBox ID="ddl_Paging1" AutoPostBack="true" runat="server" Visible="false" Width="100px" Skin="Forest"/><br /><br /> |
| <asp:Table ID="tbl_Data" runat="server"> |
| <asp:TableRow> |
| <asp:TableCell> |
| <asp:Literal ID="PivotTable" runat="server" Visible="false" /> |
| </asp:TableCell> |
| </asp:TableRow> |
| </asp:Table> |
| </asp:TableCell> |
| </asp:TableRow> |
| <asp:TableRow> |
| <asp:TableCell ColumnSpan="2"> |
| <asp:Button ID="ExportToExcel" runat="server" Text="Export" /> |
| </asp:TableCell> |
| </asp:TableRow> |
| </asp:Table> |
| </form> |
| </body> |
| </html> |


| <asp:HyperLink ID="lockerSettingsLnk" Text="windowLink" runat="server" |
| NavigateUrl="javascript:showRadWindow();" /> |
| function showRadWindow () |
| { |
| var radWindow = window.radopen(null, "myWindow"); |
| radWindow.argument = new Object(); |
| radWindow.argument.refreshParent = false; |
| } |
| <asp:Button ID="testButton" runat="server" OnClick="testButton_clicked"/> |
| <telerik:RadWindowManager id="radWindowManager" runat="server" enableembeddedskins="True"> |
| <Windows> |
| <telerik:RadWindow id="mywindow" Behaviors="Close, Move, Resize, Maximize" ReloadOnShow="true" VisibleStatusbar="true" ShowContentDuringLoad="false" |
| Left="150px" Modal="true" Runat="server" Width="600px" Height="450px" > |
| </telerik:RadWindow> |
| </Windows> |
| </telerik:RadWindowManager> |
| Protected Sub RadGrid2_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid2.UpdateCommand |
| If TypeOf e.Item Is GridEditableItem Then |
| Dim editedItem As GridEditFormItem = CType(e.Item, GridEditFormItem) |
| Dim StartTime As RadDateTimePicker = CType(editedItem.FindControl("RadDateTimePickerStart"), RadDateTimePicker) |
| Dim EndTime As RadDateTimePicker = CType(editedItem.FindControl("RadDateTimePickerEnd"), RadDateTimePicker) |
| Dim LeaveType As RadComboBox = CType(editedItem.FindControl("drpleavetype"), RadComboBox) |
| Dim LeaveRequest_Fkey As Label = CType(editedItem.FindControl("lblid"), Label) |
| End If |
| Private Sub HoursPositiveValidator_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles HoursPositiveValidator.ServerValidate |
|
'Create variable to hold instance of validation return array.
Dim ReturnArray = LeaveClass.CustomDateValidation(FirstGridDateTimePicker.selectedvalue, SecondGridDateTimePicker.selectedvalue)
|
| If returnarray(0) = "False" then args.isvalid = false End If End Sub |