or
<%@ Page Title="" Language="VB" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="MySql.Data.MySqlClient" %><script runat="server"> Protected Sub rgAlertsNeedDataSource(ByVal source As Object, ByVal e As GridNeedDataSourceEventArgs) Dim Priorities As String = "" Dim dtSelectedDate As DateTime = DateTime.Now.AddDays(-7) Dim dtEndSelectedDate As DateTime = DateTime.Now Dim HoursToPST As Integer = -8 'ddlTimeZone.SelectedValue - 8 'adjust because alerts are in PST/PDT 'If DateTime.Now().IsDaylightSavingTime Then HoursToGMT = HoursToGMT - 1 dtSelectedDate = dtSelectedDate.AddHours(HoursToPST) dtEndSelectedDate = dtEndSelectedDate.AddHours(HoursToPST) Dim SQL As String = "SELECT *, " SQL &= " Case Priority " SQL &= " WHEN 'Critical' then '5' " SQL &= " WHEN 'Major' then '4' " SQL &= " WHEN 'Minor' then '3' " SQL &= " WHEN 'Warning' then '2' " SQL &= " WHEN 'FYI' then '1' " SQL &= " End As Severity" SQL &= " FROM alert.alerts " Dim SQLWHERE As String = "" SQLWHERE = " WHERE EventName like '" & Session("ClientID") & "|%' " SQLWHERE &= " AND CreationTime BETWEEN '" & dtSelectedDate.ToString("yyyy-MM-dd HH:mm") & "' AND '" & dtEndSelectedDate.ToString("yyyy-MM-dd HH:mm") & "' " SQL &= SQLWHERE If Len(Session("OSAlertSortExpr")) > 0 Then SQL &= " ORDER BY " & Session("OSAlertSortExpr") Else SQL &= " ORDER BY CreationTime DESC " End If rgAlerts.DataSource = GetDataTable(SQL) End Sub Public Function GetDataTable(ByVal SQL As String) As DataTable Dim conn As MySqlConnection = New MySqlConnection(Session("TC_CONN")) Dim adapter As MySqlDataAdapter = New MySqlDataAdapter(SQL, conn) Dim dt As New DataTable conn.Open() Try adapter.Fill(dt) Finally conn.Close() End Try Return dt End Function</script> <telerik:RadGrid ID="rgAlerts" runat="server" OnNeedDataSource="rgAlertsNeedDataSource" > </telerik:RadGrid>RadComboBoxItem item = new RadComboBoxItem(); item.Text = selectionItem.ShortName.ToString(); item.Value = selectionItem.SelectionId.ToString(); item.Attributes.Add("SelectionNumber", selectionItem.SelectionNumber.ToString()); item.Attributes.Add("DrawnNumber", selectionItem.DrawnNumber.ToString()); radComboBoxSelection.Items.Add(item); item.DataBind();<table id="AddressTable" style="width: 100%" cellpadding="0" cellspacing="0"> <tr> <td valign="top"> <telerik:RadButton ID="ToButton" runat="server" Text="" Width="60px" AutoPostBack="false" OnClientClicked="ToggleAddressGrid" /> </td> <td style="width: 100%; padding-left: 5px; padding-bottom: 5px; padding-right: 5px"> <telerik:RadListView ID="AddressBookListView" runat="server" DataKeyNames="name,id" ClientDataKeyNames="name,id" ClientIDMode="AutoID" Width="100%" > <ClientSettings> <DataBinding> <LayoutTemplate> <div ID="#= owner.get_id() #_itemContainer" class="DataLayoutTemplate" onclick="ToggleAddressGrid(this, event, '#= owner.get_id() #')" /> </LayoutTemplate> <EmptyDataTemplate> <div class="TelerikFont EmptyDataTemplate" runat="server"> Click here or use the button to add contacts... </div> </EmptyDataTemplate> <ItemTemplate> <table runat="server" class="AddressContact TelerikFont" cellpadding="0" cellspacing="0" onclick="AddressBook_DeSelectFromAddressGrid('#= owner.get_id() #','#= id #');"> <tr> <td style="padding-left: 5px; padding-right: 5px;"> #= name # </td> <td style="width: 0; display: none; overflow: visible"> #= id # </td> <td style="padding-right: 5px;"> <img src="#= ResolveClientUrl('~/Main/Content/Images/Icons/msg_delete.gif') #" /> </td> </tr> </table> </ItemTemplate> </DataBinding> </ClientSettings> </telerik:RadListView> <div style="width: 100%; position: relative;"> <div runat="server" id="AddressGridDiv" class="AddressGridDiv"> <telerik:RadAjaxLoadingPanel ID="AddressBookLoadingPanel" runat="server" /> <telerik:RadAjaxPanel ID="AddressGridAjaxPanel" runat="server" LoadingPanelID="AddressBookLoadingPanel"> <telerik:RadGrid ID="AddressBookGrid" runat="server" AutoGenerateColumns="false" AllowFilteringByColumn="true" AllowSorting="true" AllowPaging="true" OnNeedDataSource="AddressGrid_NeedsDataSource" AllowMultiRowSelection="true"> <MasterTableView DataKeyNames="Id,Name" ClientDataKeyNames="Id,Name" AllowNaturalSort="false" Width="100%"> <SortExpressions> <telerik:GridSortExpression /> </SortExpressions> <Columns> <telerik:GridClientSelectColumn> <HeaderStyle Width="40px" /> </telerik:GridClientSelectColumn> <telerik:GridBoundColumn HeaderText="Name" SortExpression="Name" DataField="Name" FilterControlWidth="150" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" /> <telerik:GridBoundColumn SortExpression="ParentCawClient.Name" DataField="ParentCawClient.Name" HeaderText="Client Name" FilterControlWidth="150px" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" /> <telerik:GridBoundColumn HeaderText="Email Address" SortExpression="Email" DataField="Email" FilterControlWidth="150" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" /> </Columns> </MasterTableView> <ClientSettings> <Selecting AllowRowSelect="true" /> <ClientEvents OnRowSelected="AddressBook_AddRowToListView" OnRowDeselected="AddressBook_RemoveRowFromListView" OnGridCreated="AddressBook_InitGridContacts" /> <DataBinding EnableCaching="true" /> </ClientSettings> <GroupingSettings CaseSensitive="false" /> </telerik:RadGrid> </telerik:RadAjaxPanel> </div> </div> </td> </tr></table><asp:HiddenField ID="SelectedContacts" runat="server" Value="" ClientIDMode="AutoID" /><telerik:RadScriptBlock ID="AddressBookScriptBlock" runat="server"> <script type="text/javascript"> $(document).ready(function () { $("#<%= AddressGridDiv.ClientID %>").hide(); AddressBook_InitializeClientSide( $find("<%= AddressBookListView.ClientID %>"), $("#<%= SelectedContacts.ClientID %>")); }); </script></telerik:RadScriptBlock>protected void Page_Load(object sender, EventArgs e) { AddressBookListView.ClientSettings.DataBinding.ItemPlaceHolderID = AddressBookListView.ClientID + "_itemContainer"; ClientIDMode = ClientIDMode.AutoID; }<telerik:RadWindowManager ID="ViewEditMessageWindow" ShowContentDuringLoad="false" VisibleStatusbar="false" ReloadOnShow="true" runat="server" EnableShadow="true" KeepInScreenBounds="true" Left="10px" Top="10px" MinHeight="600px" MinWidth="800px"> <Windows> <telerik:RadWindow ID="ViewMessage" runat="server" Behaviors="Close" NavigateUrl="" MinHeight="600" MinWidth="800" Modal="true" Overlay="true" /> </Windows> </telerik:RadWindowManager>function NewMessage(sender, eventArgs) { var oWnd = radopen("<%= Navigator.NewMessage() %>", "ViewEditMessageWindow"); }