or
select idRecord.idfrom idRecordwhere id = 123456into temp tblTemp;select profileRecord.usernamefrom profileRecordwhere id in (select id from tbltemp)The closest post to what I want to do is: http://www.telerik.com/community/forums/aspnet-ajax/general-discussions/any-way-to-prevent-telerik-from-including-jquery.aspx
But the suggestion is to include jquery into the telerik which i dont want to do.
I want to run jquery and jquery-ui independently of telerik so that i don't have to go change all the existing:
$(document).ready(...)
code.
At the moment everything is fine, but I can't use the jQuery.ui library because telerik breaks it, and I can't include the libraries into the script manage because that breaks existing jQuery stuff.
How can i run jQuery/jQuery-UI in-dependently of Telerik stuff...
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px" Width="75px" Transparency="5"> <img style="margin-top: 150px;" alt="Loading..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading4.gif") %>' /> </telerik:RadAjaxLoadingPanel> <telerik:RadGrid ID="RadGrid1" EnableViewState="False" OnPageIndexChanged="RadGrid1_PageIndexChanged" runat="server" DataSourceID="SqlDataSource1" GridLines="None" Width="850px" Height="100%" Skin="Telerik" PageSize="20" AllowPaging="True"> <PagerStyle Mode="NumericPages" PageButtonCount="1" Position="TopAndBottom" /> <MasterTableView BorderStyle="None" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="20"> <NoRecordsTemplate> <div> Nothing was found, start your search again. To Refresh, click <a href="inventory.aspx?reset=no&make=clear&model=clear&yearFromGrid=clear"> here</a></div> </NoRecordsTemplate> <Columns> <telerik:GridBoundColumn DataField="ID" HeaderText="ID" SortExpression="ID" UniqueName="ID" DataType="System.Int32" ReadOnly="True" Visible="False" AutoPostBackOnFilter="True"> </telerik:GridBoundColumn> </Columns> <ItemTemplate> <div style="height: auto; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px;"> <table width="95%" border="0" cellspacing="0" cellpadding="0"> <tr style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <td style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <div style="font-size: medium; font-weight: bold; text-align: left;"> <a class="nikfont2" style="color: black; font-size: medium;"><%#Eval("Year") & " " & Eval("Make") & " " & Eval("Model") %></a></div> </td> <tr style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <td style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <table border="0"> <tr style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <td style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <div runat="server" visible="false" id="myDiv"> <%#Eval("Stock Number") %></div> <br /> </td> <td style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <a href="productdetails.aspx?sid=<%#Eval("Stock Number") %>&sysn=<%#Eval("Sys2KNum") %>"> <img id="imgItem1" alt="" src="<%# GetJobImageHtml(DirectCast(Eval("Stock Number"), String), DirectCast(Eval("PicturePackage"), String),DirectCast(Eval("Sys2KNum"), String) )%>" style="width: 120px; border: 1px solid rgb(195, 195, 195);" /> </a> </td> <td style="text-align: left; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <table style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <tr style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <td width="60px"> Stock #:<br /> Int Color:<br /> UVW:<br /> Length:<br /> Category:<br /> </td> <td width="100px" style=""> <%#eval("Stock Number") %><br /> <%# Eval("Color")%><br /> <%# Eval("Weight")%><br /> <%# LengthOuputer(DirectCast(myCStr(Eval("Length")), String))%><br /> <%# Eval("InternetClass") %><br /> </td> </tr> <tr style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <td colspan="4" style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <span id="lblDescription"> <%--IIf(myCStr(Eval("Sales Description")) <> "", myCStr(Eval("Sales Description")).ToString().Substring(0, Math.Min(150, myCStr(Eval("Sales Description")).Length)) & "... <a href=""productdetails.aspx?sid=" & myCStr(Eval("Stock Number")) & """>[View More]</a>", "")--%> </span> </td> </tr> </table> </td> <td width="250px"> <table style="border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px"> <tr> <td> <%# loadAddress(DirectCast(myCStr(Eval("Address1")), String), _ DirectCast(myCStr(Eval("Address2")), String), _ DirectCast(myCStr(Eval("City")), String), _ DirectCast(myCStr(Eval("State")), String), _ DirectCast(myCStr(Eval("Zip")), String), _ DirectCast(myCStr(Eval("MainPhone")), String))%> <telerik:RadRating ID="RadRating1" runat="server" AutoPostBack="False" OnRate="RadRating1_Rate" Precision="Exact" /> <%--<telerik:RadRating ID="RadRating1" runat="server" AutoPostBack="True" OnRate="RadRating1_Rate" Precision="Exact" />--%> <%-- <telerik:RadComboBox ID="RadComboBox1" runat="server" OnSelectedIndexChanged="RadRating1_Rate"> <Items> <telerik:RadComboBoxItem runat="server" Text="Select Criteria" Value="none" Selected="True" /> <telerik:RadComboBoxItem runat="server" Text="Length Ascending" Value="LengthA" Selected="False" /> </Items> </telerik:RadComboBox>--%> </td> <td width="120px"> <div style="font-size: large; font-weight: bold; vertical-align: top"> <%# price(DirectCast(myCStr(Eval("SalePrice")), String), _ DirectCast(myCStr(Eval("Suggested Selling Price")), String), _ DirectCast(myCStr(Eval("OurPrice")), String), _ DirectCast(myCStr(Eval("SpecialPrice")), String), _ DirectCast(myCStr(Eval("MSRP")), String), _ DirectCast(myCStr(Eval("Sys2KNum")), String))%> </div> <div > <a href="productdetails.aspx?sid=<%#Eval("Stock Number") %>&sysn=<%#Eval("Sys2KNum") %>"> <img src="images/viewdetails.png" alt="" name="<%#Eval("Stock Number") %>" border="0" style="margin-bottom: 5px" /></a><br /> </div> <br /> <div> <%# zip(DirectCast(myCStr(Eval("Radius")), String), DirectCast(myCStr(Eval("DealerCity")), String))%> </div> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </div> </ItemTemplate> <EditFormSettings> <FormTemplate> </FormTemplate> </EditFormSettings> <PagerStyle Mode="NumericPages" Position="TopAndBottom" /> </MasterTableView> <ActiveItemStyle BorderStyle="None" /> </telerik:RadGrid> </td> </tr></table><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestString %>" SelectCommand="SELECT * FROM Vehicles WHERE Sys2KNum = '007414'" ></asp:SqlDataSource><telerik:RadGrid ID="RadGrid1" EnableViewState="False" OnPageIndexChanged="RadGrid1_PageIndexChanged" runat="server" DataSourceID="SqlDataSource1" GridLines="None" Width="850px" Height="100%" Skin="Telerik" PageSize="20" AllowPaging="True"> <PagerStyle Mode="NumericPages" PageButtonCount="1" Position="TopAndBottom" /> <MasterTableView BorderStyle="None" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="20"> <NoRecordsTemplate> <div> Nothing was found, start your search again. To Refresh, click <a href="inventory.aspx?reset=no&make=clear&model=clear&yearFromGrid=clear"> here</a></div> </NoRecordsTemplate> <Columns> <telerik:GridBoundColumn DataField="ID" HeaderText="ID" SortExpression="ID" UniqueName="ID" DataType="System.Int32" ReadOnly="True" Visible="False" AutoPostBackOnFilter="True"> </telerik:GridBoundColumn> </Columns> <itemTemplate> <asp:UpdatePanel runat="server" ID="panel1"> <ContentTemplate> <telerik:RadRating ID="RadRating1" Value="3.5" runat="server" AutoPostBack="false" Precision="Exact" /> </ContentTemplate> </asp:UpdatePanel></ItemTemplate> <EditFormSettings> <FormTemplate> </FormTemplate> </EditFormSettings> <PagerStyle Mode="NumericPages" Position="TopAndBottom" /> </MasterTableView> <ActiveItemStyle BorderStyle="None" /> </telerik:RadGrid>Private Sub RadGrid1_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemCreated If Not IsPostBack Then For Each gridDataItem As GridDataItem In RadGrid1.Items Dim radRate As RadRating = DirectCast(gridDataItem.FindControl("RadRating1"), RadRating) AddHandler radRate.Rate, AddressOf CControls_UnitGrid.Rate radRate.Value = 1 radRate.AutoPostBack = True Dim panel1 As UpdatePanel = DirectCast(gridDataItem.FindControl("panel1"), UpdatePanel) AddHandler panel1.Load, AddressOf CControls_UnitGrid.Rate Next End IfEnd SubShared Sub Rate(ByVal sender As Object, ByVal e As EventArgs) Dim radRate As RadRating = DirectCast(sender, RadRating) radRate.Value = 2 End Sub
private void Page_Load(object sender, EventArgs e)
{
RadScheduler1.AppointmentCreated += RadScheduler1_AppointmentCreated;
RadScheduler1.DataBound += RadScheduler1_DataBound;
this.RadScheduler1.DataSource = GetApps();
this.RadScheduler1.DataBind();
}
private List<Appointment> GetApps()
{
List<Appointment> appList = new List<Appointment>();
for (int i = 0; i < 10; i++)
{
Appointment app = new Appointment();
app.ID = Guid.NewGuid();
app.Subject = "Apt" + i.ToString();
app.Start = DateTime.Now.AddDays(i);
app.End = DateTime.Now.AddDays(i).AddMinutes(30);
appList.Add(app);
}
return appList;
}
protected void RadScheduler1_AppointmentCreated(object sender, AppointmentCreatedEventArgs e)
{
if (e.Appointment.Visible && !IsAppointmentRegisteredForTooltip(e.Appointment))
{
string id = e.Appointment.ID.ToString();
foreach (string domElementID in e.Appointment.DomElements)
{
RadToolTipManager1.TargetControls.Add(domElementID, id, true);
}
}
}
private bool IsAppointmentRegisteredForTooltip(Appointment apt)
{
foreach (ToolTipTargetControl targetControl in RadToolTipManager1.TargetControls)
{
if (apt.DomElements.Contains(targetControl.TargetControlID))
{
return true;
}
}
return false;
}
protected void RadScheduler1_DataBound(object sender, EventArgs e)
{
RadToolTipManager1.TargetControls.Clear();
ScriptManager.RegisterStartupScript(this, typeof(Page), "HideToolTip", "hideActiveToolTip();", true);
}
protected void RadToolTipManager1_AjaxUpdate(object sender, ToolTipUpdateEventArgs e)
{
Appointment apt = RadScheduler1.Appointments.FindByID(new Guid(e.Value));
Portal_Controls_AppointmentToolTip toolTip = (Portal_Controls_AppointmentToolTip)LoadControl("Portal/Controls/AppointmentToolTip.ascx");
toolTip.TargetAppointment = apt;
e.UpdatePanel.ContentTemplateContainer.Controls.Add(toolTip);
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="Test" %><%@ Reference Control="Portal/Controls/AppointmentToolTip.ascx" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <link rel="stylesheet" type="text/css" href="/Resources/css/styles.css" /> <script language="javascript" src="/Resources/js/modals.js" type="text/javascript"></script> <script type="text/javascript"> //<![CDATA[ function hideActiveToolTip() { var tooltip = Telerik.Web.UI.RadToolTip.getCurrent(); if (tooltip) { tooltip.hide(); } } Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginRequestHandler); function beginRequestHandler(sender, args) { var prm = Sys.WebForms.PageRequestManager.getInstance(); if (args.get_postBackElement().id.indexOf('RadScheduler1') != -1) { hideActiveToolTip(); } } function clientBeforeShow(sender, eventArgs) { w = $telerik.$(window).width() / 2; h = $telerik.$(window).height() / 2; if ((sender._mouseX > w) && (sender._mouseY > h)) { sender.set_position(Telerik.Web.UI.ToolTipPosition.TopLeft); return; } if ((sender._mouseX < w) && (sender._mouseY > h)) { sender.set_position(Telerik.Web.UI.ToolTipPosition.TopRight); return; } if ((sender._mouseX > w) && (sender._mouseY < h)) { sender.set_position(Telerik.Web.UI.ToolTipPosition.BottomLeft); return; } sender.set_position(Telerik.Web.UI.ToolTipPosition.BottomRight); } //]]> </script></head><body id="body" runat="server" style="background-color:White;"> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> <div style="padding:20px 20px 20px 20px;"> <asp:UpdatePanel runat="server" ID="UpdatePanel1" UpdateMode="Conditional"> <ContentTemplate> <telerik:RadScheduler runat="server" ID="RadScheduler1" Width="750px" Height="600px" TimeZoneOffset="03:00:00" DayStartTime="08:00:00" DayEndTime="18:00:00" DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start" DataEndField="End" DisplayDeleteConfirmation="false" SelectedView="MonthView"> <AdvancedForm Modal="true" /> <TimelineView UserSelectable="false" /> <TimeSlotContextMenuSettings EnableDefault="true" /> <AppointmentContextMenuSettings EnableDefault="true" /> </telerik:RadScheduler> <telerik:RadToolTipManager runat="server" ID="RadToolTipManager1" Width="320" Height="210" Animation="None" HideEvent="LeaveToolTip" Text="Loading..." RelativeTo="Element" OnAjaxUpdate="RadToolTipManager1_AjaxUpdate" OnClientBeforeShow="clientBeforeShow" EnableShadow="true"/> </ContentTemplate> </asp:UpdatePanel> </div> </form></body></html>