or
<telerik:RibbonBarSplitButton ID="testSplit" Text="Split Button" Size="Large" ImageUrlLarge="Enabled.png" DisabledImageUrlLarge="Disabled.png" ImageRenderingMode="Dual" Enabled="true" > <Buttons> <telerik:RibbonBarButton ID="testSub1" Text="Option 1" ImageUrl="MyIcon.png" DisabledImageUrl="MyIconDis.png" Enabled="false" Value="alert('Option 1 clicked')" /> <telerik:RibbonBarButton ID="testSub2" Text="Option 2" ImageUrl="MyIcon.png" DisabledImageUrl="MyIconDis.png" Enabled="false" Value="alert('Option 2 clicked')" /> </Buttons></telerik:RibbonBarSplitButton>CREATE PROCEDURE [dbo].[sp_Events_GetNext10EventsIncludeRecurring]ASBEGIN SET NOCOUNT ON; DECLARE @StartDate DATETIME; DECLARE @EndDate DATETIME; SET @StartDate = CAST(CONVERT(VARCHAR,GETDATE(),21) AS DATETIME); SET @EndDate = CAST(CONVERT(VARCHAR,GETDATE()+365,21) AS DATETIME); -- List all appointments (recurring or not) in the given rangeSELECT TOP 10 a.[EventID] as [EventID], a.[EventName] as [EventName], a.[Description] as [Description], a.[Location], ISNULL(o.StartDate, a.[StartDateTime]) as [StartDateTime], ISNULL(o.EndDate, a.[EndDateTime]) as [EndDateTime], a.[RecurrenceRule] as [RecurrenceRule], a.[RecurrenceParentID] as [RecurrenceParentID], a.[EventTypeID] as [EventTypeID], a.[EventType] as [EventType], a.[EventCategoryID] as [EventCategoryID], a.[EventCategory] as [EventCategory], a.[VenueID] as [VenueID], a.[VenueName] as [VenueName], a.[IsCityVenue] as [IsCityVenue], a.[RSVP] as [RSVP], a.[MinAttendees] as [MinAttendees], a.[MaxAttendees] as [MaxAttendees], a.[Notes] as [Notes], a.[AddedBy] as [AddedBy], a.[EditedBy] as [EditedBy], a.[DateAdded] as [DateAdded], a.[LastEdited] as [LastEdited], a.[Status] as [Status]FROM [vw_Details_Events_Active] a OUTER APPLY [dbo].[ExpandRecurrence](a.[RecurrenceRule], @Startdate, @EndDate) AS oWHERE -- Include non-recurring appointments in the range (a.[RecurrenceRule] IS NULL AND a.[StartDateTime] < @EndDate AND a.[EndDateTime] > @StartDate) OR -- And recurring appointments in range. (a.[RecurrenceRule] IS NOT NULL AND o.[StartDate] < @EndDate AND o.[EndDate] > @StartDate)ORDER BY [StartDateTime]END<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function ExternalitemOpened(s, e) { if ($telerik.isIE8) { // Fix an IE 8 bug that causes the list bullets to disappear (standards mode only) $telerik.$("li", e.get_item().get_element()) .each(function () { this.style.cssText = this.style.cssText; }); } } function External_MouseOver(sender, args) { if (args.get_item().get_parent() == sender) { sender.set_clicked(false); } } function ExternalOnClientItemClicking(sender, args) { if (args.get_item().get_isOpen() == true) { args.set_cancel(true); args.get_item().close(); } } </script> </telerik:RadCodeBlock><telerik:RadMenu ID="RadMenu_SpecialReport" runat="server" ClickToOpen="True" EnableShadows="True" OnClientItemOpened="ExternalitemOpened" OnClientItemClicking="ExternalOnClientItemClicking" OnClientMouseOut="External_MouseOver" Style="top: 0px; left: -2px; z-index: 100; height: 35px;" Skin="ExternalGridButtons" EnableEmbeddedSkins="false"> <Items> <telerik:RadMenuItem PostBack="true" Text="Special Reports" Value="Special_Reports" CssClass="btn btn-primary btn-menu-grid-size"> <ContentTemplate> <div id="Special_panel" class="Special_panel" style="width:300px; height:500px; background-color:white;"> <telerik:RadAjaxPanel ID="RadAjaxPanel_SpecialReport" runat="server" Width="80%"></telerik:RadAjaxPanel> <telerik:RadButton ID="btn_ShowSpecialReport" runat="server" Text="Show Special Report" Skin="Web20" CssClass="btn_Sort" OnClick="btn_ShowSpecialReport_Click"></telerik:RadButton> </div> </ContentTemplate> </telerik:RadMenuItem> <telerik:RadMenuItem PostBack="true" Text="zzzz" Value="zzzzz" CssClass="btn btn-primary btn-menu-grid-size"> <ContentTemplate> <div id="Div1" class="Special_panel" style="width:300px; height:500px; background-color:white;"> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Width="80%"></telerik:RadAjaxPanel> <telerik:RadButton ID="RadButton2" runat="server" Text="Show Special Report" Skin="Web20" CssClass="btn_Sort" OnClick="btn_ShowSpecialReport_Click"></telerik:RadButton> </div> </ContentTemplate> </telerik:RadMenuItem> <telerik:RadMenuItem IsSeparator="true"></telerik:RadMenuItem> </Items> </telerik:RadMenu><%@ Control Language="C#" AutoEventWireup="true" CodeFile="mw_ora_prnt_acct_info.ascx.cs" Inherits="Telerik.Web.Examples.ToolTip.ToolTipVersusToolTipManager.InfoCustomers" %><asp:Panel ID="cust_info_pnl" runat="server"> <asp:Table ID="cust_info_tbl" runat="server" Width="500px"> <asp:TableRow> <asp:TableCell ColumnSpan="2" style="font:20px Yanone Kaffeesatz;color:Black;border-bottom:1px solid Black;text-align:left;">Company Information</asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Company Name:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:TextBox ID="prnt_acct_name_txt" Width="300px" runat="server" CssClass="txtbox"></asp:TextBox></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Account Type:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="acct_type_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="EMPLOYER">EMPLOYER</asp:ListItem> <asp:ListItem Value="NONE">NONE</asp:ListItem> <asp:ListItem Value="PHYSICIAN NETWORK">PHYSICIAN NETWORK</asp:ListItem> </asp:DropDownList> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">WW Contract Date:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:TextBox ID="acct_cntrct_date_txt" Width="75px" runat="server" ReadOnly="true" BackColor="LightSlateGray" CssClass="txtbox"></asp:TextBox></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">ES Follow-Up Date:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:TextBox ID="fu_date_txt" Width="75px" runat="server" CssClass="txtbox"></asp:TextBox></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">ES Priority:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="es_priority_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="6TH">6TH</asp:ListItem> <asp:ListItem Value="5TH">5TH</asp:ListItem> <asp:ListItem Value="4TH">4TH</asp:ListItem> <asp:ListItem Value="3RD">3RD</asp:ListItem> <asp:ListItem Value="2ND">2ND</asp:ListItem> <asp:ListItem Value="1ST">1ST</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell ColumnSpan="2" style="font:20px Yanone Kaffeesatz;color:Black;border-bottom:1px solid Black;text-align:left;">Carrier Information</asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right"></asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Insurance Carrier:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:TextBox ID="ins_carrier_txt" Width="300px" runat="server" CssClass="txtbox"></asp:TextBox> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell> </asp:TableCell> <asp:TableCell><telerik:RadComboBox ID="ins_carrier_combo" runat="server" Height="200" Width="640" DropDownWidth="720" EmptyMessage="Choose a Carrier" HighlightTemplatedItems="true" EnableLoadOnDemand="true" Filter="StartsWith" OnItemsRequested="ins_carrier_combo_ItemsRequested" OnAjaxUpdate="OnAjaxUpdate"> <HeaderTemplate> <table style="width: 670px" cellspacing="0" cellpadding="0"> <tr> <td style="width: 550px;"> Carrier Name </td> <td style="width: 120px; text-align: left;"> Account Number </td> </tr> </table> </HeaderTemplate> <ItemTemplate> <table style="width: 670px" cellspacing="0" cellpadding="0"> <tr> <td style="width: 550px;"> <%# DataBinder.Eval(Container, "Attributes['ACCOUNT_NAME']")%> </td> <td style="width: 120px; text-align: left;"> <%# DataBinder.Eval(Container, "Attributes['ACCOUNT_NUMBER']")%> </td> </tr> </table> </ItemTemplate> </telerik:RadComboBox></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Carrier Renewal Date:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:TextBox ID="renewal_date_txt" Width="75px" runat="server" CssClass="txtbox"></asp:TextBox></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Broker Code:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:TextBox ID="broker_code_txt" Width="35px" runat="server" CssClass="txtbox"></asp:TextBox></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right"></asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell ColumnSpan="2" style="font:20px Yanone Kaffeesatz;color:Black;border-bottom:1px solid Black;text-align:left;">Misc Information</asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Ancillary Services:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="ancil_svcs_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="Y">YES</asp:ListItem> <asp:ListItem Value="N">NO</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Alternate PT:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="alt_pt_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="Y">YES</asp:ListItem> <asp:ListItem Value="N">NO</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Alternate RX:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="alt_rx_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="Y">YES</asp:ListItem> <asp:ListItem Value="N">NO</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Alternate DX:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="alt_dx_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="Y">YES</asp:ListItem> <asp:ListItem Value="N">NO</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell ColumnSpan="2" style="font:20px Yanone Kaffeesatz;color:Black;border-bottom:1px solid Black;text-align:left;">Account Status</asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Status:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="acct_status_drp" runat="server" CssClass="txtbox" OnSelectedIndexChanged="acct_status_chngd" AutoPostBack="true"> <asp:ListItem Value="A">ACTIVE</asp:ListItem> <asp:ListItem Value="I">INACTIVE</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow ID="acct_inactive_row" runat="server" Visible="false"> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right">Try To Get Back:</asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Left"><asp:DropDownList ID="inactive_try_to_bet_bck_drp" runat="server" CssClass="txtbox"> <asp:ListItem Value="-"> MAKE A SELECTION </asp:ListItem> <asp:ListItem Value="Y">YES - AT NEXT RENEWAL</asp:ListItem> <asp:ListItem Value="N">NO</asp:ListItem> </asp:DropDownList></asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell Width="150px" Wrap="false" HorizontalAlign="Right"></asp:TableCell> <asp:TableCell Wrap="false" HorizontalAlign="Right"> <telerik:radbutton id="submit_srch_btn" runat="server" text="UPDATE" Width="50" OnClick="acct_update_submit"/> <telerik:radbutton id="cancel_update_btn" runat="server" text="CANCEL" Width="50" OnClick="acct_update_cancel"/> </asp:TableCell> </asp:TableRow> </asp:Table> </asp:Panel>using System;using System.Collections;using System.Collections.Generic;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using Oracle.DataAccess.Client;using Telerik.Web.UI;namespace Telerik.Web.Examples.ToolTip.ToolTipVersusToolTipManager{ public partial class InfoCustomers : System.Web.UI.UserControl { private string _party_id; public string Party_ID { get { return _party_id; } set { _party_id = value; } } protected void Page_PreRender(object sender, EventArgs e) { get_acct_info(); } protected void Page_Load(object sender, EventArgs e) { cust_info_pnl.Visible = true; } private OracleConnection CreateConnection() { string ora_db = "Data Source=(DESCRIPTION=" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxxx)))" //test server + "(CONNECT_DATA=(SERVICE_NAME=xxxx)));" + "User Id=xxxx;Password=xxxx;"; return new OracleConnection(ora_db); } protected void acct_update_submit(object sender, EventArgs e) { } protected void acct_update_cancel(object sender, EventArgs e) { get_acct_info(); } protected void acct_status_chngd(object sender, EventArgs e) { if (acct_status_drp.SelectedValue == "A") { acct_inactive_row.Visible = false; } else { acct_inactive_row.Visible = true; } } protected void get_acct_info() { OracleConnection conn = CreateConnection(); try { conn.Open(); DataTable information = new DataTable(); try { string sql = "SELECT PARTY_NAME, ATTRIBUTE_CATEGORY, ATTRIBUTE1 ,ATTRIBUTE2, ATTRIBUTE3,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 " + " FROM AR.HZ_PARTIES " + " WHERE PARTY_TYPE = 'ORGANIZATION' " + " AND ATTRIBUTE_CATEGORY = 'EMPLOYER' " + " AND PARTY_ID = " + _party_id; OracleCommand cmd = new OracleCommand(sql, conn); OracleDataReader dr3 = cmd.ExecuteReader(); if (dr3.Read()) { prnt_acct_name_txt.Text = Convert.ToString(dr3.GetValue(0)); acct_type_drp.SelectedValue = Convert.ToString(dr3.GetValue(1)); acct_cntrct_date_txt.Text = Convert.ToDateTime(dr3.GetValue(2)).ToString("dd-MMM-yyyy"); fu_date_txt.Text = Convert.ToDateTime(dr3.GetValue(3)).ToString("dd-MMM-yyyy"); es_priority_drp.SelectedValue = Convert.ToString(dr3.GetValue(9)); ins_carrier_txt.Text = Convert.ToString(dr3.GetValue(10)); ins_carrier_combo.Text = Convert.ToString(dr3.GetValue(10)); renewal_date_txt.Text = Convert.ToDateTime(dr3.GetValue(4)).ToString("dd-MMM-yyyy"); broker_code_txt.Text = Convert.ToString(dr3.GetValue(11)); ancil_svcs_drp.SelectedValue = Convert.ToString(dr3.GetValue(5)); alt_pt_drp.SelectedValue = Convert.ToString(dr3.GetValue(6)); alt_rx_drp.SelectedValue = Convert.ToString(dr3.GetValue(7)); alt_dx_drp.SelectedValue = Convert.ToString(dr3.GetValue(8)); } dr3.Close(); dr3.Dispose(); } finally { } } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } protected void ins_carrier_combo_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { OracleDataAdapter adapter = new OracleDataAdapter("SELECT HP.PARTY_NAME, HCA.ACCOUNT_NAME, HCA.ACCOUNT_NUMBER, HCA.CUST_ACCOUNT_ID " + " FROM AR.HZ_CUST_ACCOUNTS HCA " + " INNER JOIN AR.HZ_PARTIES HP ON HP.PARTY_ID = HCA.PARTY_ID " + " WHERE HCA.ATTRIBUTE_CATEGORY = 'INSURANCE CARRIER' AND " + " HCA.STATUS = 'A' AND " + " HCA.ACCOUNT_NAME LIKE '" + e.Text.ToUpper() + "%' " + " ORDER BY ACCOUNT_NUMBER ", ConfigurationManager.ConnectionStrings["oracle_db"].ConnectionString); DataTable dataTable = new DataTable(); adapter.Fill(dataTable); foreach (DataRow dataRow in dataTable.Rows) { RadComboBoxItem item = new RadComboBoxItem(); item.Text = (string)dataRow["ACCOUNT_NAME"]; item.Value = dataRow["CUST_ACCOUNT_ID"].ToString(); string unitPrice = (string)dataRow["ACCOUNT_NAME"]; string unitsInStock = (string)dataRow["ACCOUNT_NUMBER"]; item.Attributes.Add("ACCOUNT_NAME", unitPrice.ToString()); item.Attributes.Add("ACCOUNT_NUMBER", unitsInStock.ToString()); ins_carrier_combo.Items.Add(item); item.DataBind(); } } }}