or
select
idRecord.id
from
idRecord
where
id = 123456
into
temp tblTemp
;
select
profileRecord.username
from
profileRecord
where
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
If
End
Sub
Shared
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
>