void
radToolTip_DataBinding(
object
sender, EventArgs e)
{
System.Web.UI.WebControls.Image i =
new
System.Web.UI.WebControls.Image();
i.ID =
"toolTipImage"
;
i.Height = 600;
i.Width = 800;
RadToolTipManager r = (RadToolTipManager)sender;
r.ID =
"radToolTip"
;
radToolTip.TargetControls.Add(image.ClientID,
true
);
GridDataItem container = (GridDataItem)r.NamingContainer;
r.Animation = ToolTipAnimation.FlyIn;
r.RelativeTo = ToolTipRelativeDisplay.Element;
i.ImageUrl = ((DataRowView)container.DataItem)[colname].ToString();
r.Text = i.ImageUrl.ToString();
r.Title = ((DataRowView)container.DataItem)[
"Description"
].ToString();
r.Controls.Add(i);
}
<
div
id
=
"ctl00_MainPlaceHolder_SummaryGrid_ctl00_ctl14_radToolTip"
style
=
"display:none;position:absolute;"
>
<
div
id
=
"ctl00_MainPlaceHolder_SummaryGrid_ctl00_ctl14_eflyerTooltipRTMPanel"
style
=
"display: block;"
> </
div
>
<
img
id
=
"ctl00_MainPlaceHolder_SummaryGrid_ctl00_ctl14_toolTipImage"
style
=
"height:600px;width:800px;"
src
=
"http://www.fakebutcorrecturl.jpg"
>
<
input
id
=
"ctl00_MainPlaceHolder_SummaryGrid_ctl00_ctl14_radToolTip_ClientState"
type
=
"hidden"
name
=
"ctl00_MainPlaceHolder_SummaryGrid_ctl00_ctl14_radToolTip_ClientState"
>
</
div
>
/*global*/
.RadGrid_Office2010Blue {
border: 1px solid #8ba0bc;
background: #fff;
/*font: normal 12px "Segoe UI", Arial, Helvetica, sans-serif;*/
font-family: "Lucida Sans";
color: black !important;
line-height: 16px; }
.RadGrid_Office2010Blue .rgMasterTable, .RadGrid_Office2010Blue .rgDetailTable, .RadGrid_Office2010Blue .rgGroupPanel table, .RadGrid_Office2010Blue .rgCommandRow table, .RadGrid_Office2010Blue .rgEditForm table, .RadGrid_Office2010Blue .rgPager table {
/*font: normal 18px "Segoe UI", Arial, Helvetica, sans-serif;*/
line-height: 16px;
font-family: Calibri !important; /* 03/05/2014 added word !important, in order to override original css which build-in*/
color: black !important;
font-size: 10pt !important;
}
.GridToolTip_Office2010Blue {
font: normal 12px "Segoe UI", Arial, Helvetica, sans-serif;
line-height: 16px; }
.RadGrid_Office2010Blue .rgHeader:first-child, .RadGrid_Office2010Blue th.rgResizeCol:first-child, .RadGrid_Office2010Blue .rgFilterRow > td:first-child, .RadGrid_Office2010Blue .rgRow > td:first-child, .RadGrid_Office2010Blue .rgAltRow > td:first-child {
border-left-width: 0;
padding-left: 8px; }
.RadGrid_Office2010Blue .rgSave, .RadGrid_Office2010Blue .rgAdd, .RadGrid_Office2010Blue .rgRefresh, .RadGrid_Office2010Blue .rgEdit, .RadGrid_Office2010Blue .rgDel, .RadGrid_Office2010Blue .rgFilter, .RadGrid_Office2010Blue .rgPagePrev, .RadGrid_Office2010Blue .rgPageNext, .RadGrid_Office2010Blue .rgPageFirst, .RadGrid_Office2010Blue .rgPageLast, .RadGrid_Office2010Blue .rgExpand, .RadGrid_Office2010Blue .rgCollapse, .RadGrid_Office2010Blue .rgSortAsc, .RadGrid_Office2010Blue .rgSortDesc, .RadGrid_Office2010Blue .rgUpdate, .RadGrid_Office2010Blue .rgCancel, .RadGrid_Office2010Blue .rgUngroup, .RadGrid_Office2010Blue .rgExpXLS, .RadGrid_Office2010Blue .rgExpDOC, .RadGrid_Office2010Blue .rgExpPDF, .RadGrid_Office2010Blue .rgExpCSV {
background-image: url('Grid/sprite.png'); }
* html .RadGrid_Office2010Blue .rgAdd,
* html .RadGrid_Office2010Blue .rgRefresh,
* html .RadGrid_Office2010Blue .rgEdit,
* html .RadGrid_Office2010Blue .rgDel,
* html .RadGrid_Office2010Blue .rgFilter,
* html .RadGrid_Office2010Blue .rgPagePrev,
* html .RadGrid_Office2010Blue .rgPageNext,
* html .RadGrid_Office2010Blue .rgPageFirst,
* html .RadGrid_Office2010Blue .rgPageLast,
* html .RadGrid_Office2010Blue .rgExpand,
* html .RadGrid_Office2010Blue .rgCollapse,
* html .RadGrid_Office2010Blue .rgSortAsc,
* html .RadGrid_Office2010Blue .rgSortDesc,
* html .RadGrid_Office2010Blue .rgUpdate,
* html .RadGrid_Office2010Blue .rgCancel,
* html .RadGrid_Office2010Blue .rgUngroup,
* html .RadGrid_Office2010Blue .rgExpXLS,
* html .RadGrid_Office2010Blue .rgExpDOC,
* html .RadGrid_Office2010Blue .rgExpPDF,
* html .RadGrid_Office2010Blue .rgExpCSV,
* html .RadGrid_Office2010Blue .rgHeaderDiv,
* html .RadGrid_Office2010Blue .rgHeader,
* html .RadGrid_Office2010Blue th.rgResizeCol,
* html .RadGrid_Office2010Blue .rgSelectedRow,
* html .RadGrid_Office2010Blue .rgSelectedRow.rgHoveredRow,
* html .RadGrid_Office2010Blue .rgActiveRow,
* html .RadGrid_Office2010Blue .rgHoveredRow,
* html .RadGrid_Office2010Blue .rgFooterDiv,
* html .RadGrid_Office2010Blue .rgFooter,
* html .RadGrid_Office2010Blue .rgPager,
* html .RadGrid_Office2010Blue .rgPager .rgPagerButton,
* html .RadGrid_Office2010Blue .rgNumPart a:hover,
* html .RadGrid_Office2010Blue .rgNumPart a:hover span,
* html .RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage,
* html .RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage span,
* html .GridReorderTop_Office2010Blue,
* html .GridReorderBottom_Office2010Blue,
* html .RadGrid_Office2010Blue .rgGroupItem,
* html .RadGrid_Office2010Blue .rgCommandRow {
background-image: url('Grid/sprite.gif'); }
/*header*/
.RadGrid_Office2010Blue .rgHeaderDiv {
background: #d6e5f3 0 -8050px repeat-x url('Grid/sprite.png'); }
.rgTwoLines .rgHeaderDiv {
background-position: 0 -7550px; }
.RadGrid_Office2010Blue .rgHeader, .RadGrid_Office2010Blue th.rgResizeCol, .RadGrid_Office2010Blue .rgHeaderWrapper
{
background-color: #4f81bd;
color: #fff;
border-bottom: 2px solid #c0504d;
border-left: 1px solid #7ba0cd;
border-right: 1px solid #7ba0cd;
border-top: 1px solid #7ba0cd;
font-family: Arial;
font-size: 11pt;
}
.RadGrid_Office2010Blue .rgHeaderDiv {
border-right-color: #9babc2; }
.RadGrid_Office2010Blue .rgMultiHeaderRow th.rgHeader, .RadGrid_Office2010Blue .rgMultiHeaderRow th.rgResizeCol {
border: solid #8ba0bc;
border-width: 0 0 1px 1px;
background: #bdcbde 0 -2300px repeat-x url('Grid/sprite.png');
}
.RadGrid_Office2010Blue th.rgSorted {
border-bottom-color: #c28a30;
background-color: #fff27e;
background-position: 0 -2600px; }
.RadGrid_Office2010Blue .rgHeader, .RadGrid_Office2010Blue th.rgSorted {
color: #384e73; }
.RadGrid_Office2010Blue .rgHeader a, .RadGrid_Office2010Blue th.rgSorted a
{
color: #ffffff;
font-weight: bold;
}
.RadGrid_Office2010Blue .rgRow td, .RadGrid_Office2010Blue .rgAltRow td, .RadGrid_Office2010Blue .rgEditRow td, .RadGrid_Office2010Blue .rgFooter td {
border-style: solid;
border-width: 0 0 1px 1px;
}
.RadGrid_Office2010Blue .rgRow td, .RadGrid_Office2010Blue .rgAltRow td {
border-color: #7ba0cd;
}
.RadGrid_Office2010Blue .rgRow .rgSorted, .RadGrid_Office2010Blue .rgAltRow .rgSorted {
background-color: #ecf2f9; }
.RadGrid_Office2010Blue .rgSelectedRow .rgSorted, .RadGrid_Office2010Blue .rgActiveRow .rgSorted, .RadGrid_Office2010Blue .rgHoveredRow .rgSorted, .RadGrid_Office2010Blue .rgEditRow .rgSorted {
background-color: transparent; }
.RadGrid_Office2010Blue .rgRow a, .RadGrid_Office2010Blue .rgAltRow a, .RadGrid_Office2010Blue .rgEditRow a, .RadGrid_Office2010Blue .rgFooter a, .RadGrid_Office2010Blue .rgEditForm a {
color: #384e73; }
.RadGrid_Office2010Blue .rgMasterTable .rgSelectedCell {
background: #f8d05c 0 -3900px repeat-x url('Grid/sprite.png'); }
.RadGrid_Office2010Blue .rgSelectedRow
{
background: #f8d05c 0 -3900px repeat-x url('Grid/sprite.png');
}
.RadGrid_Office2010Blue .rgSelectedRow > td {
background-position: 0 100%;
background-repeat: repeat-x; }
.RadGrid_Office2010Blue .rgSelectedRow.rgHoveredRow {
background: #fcebb9 0 -3200px repeat-x url('Grid/sprite.png'); }
.RadGrid_Office2010Blue .rgSelectedRow.rgHoveredRow td {
background-image: none; }
/*rows*/
* + html .RadGrid_Office2010Blue .rgSelectedRow .rgSorted, * html .RadGrid_Office2010Blue .rgSelectedRow .rgSorted {
background-color: #ffcb60; }
.RadGrid_Office2010Blue .rgRow:hover
{
background: #d8e4bc;
}
.RadGrid_Office2010Blue .rgAltRow:hover
{
background: #d8e4bc;
}
.RadGrid_Office2010Blue .rgMasterTable .rgActiveCell, .RadGrid_Office2010Blue .rgActiveRow, .RadGrid_Office2010Blue .rgHoveredRow {
background: #d8e4bc; }
* + html .RadGrid_Office2010Blue .rgActiveRow .rgSorted, * + html .RadGrid_Office2010Blue .rgHoveredRow .rgSorted {
background-color: #ecf4ff; }
* html .RadGrid_Office2010Blue .rgActiveRow .rgSorted, * html .RadGrid_Office2010Blue .rgHoveredRow .rgSorted {
background-color: #ecf4ff; }
.RadGrid_Office2010Blue .rgEditRow {
background: #ebebeb; }
* + html .RadGrid_Office2010Blue .rgEditRow .rgSorted, * html .RadGrid_Office2010Blue .rgEditRow .rgSorted {
background-color: #ffe5ad; }
.RadGrid_Office2010Blue .rgSelectedRow td, .RadGrid_Office2010Blue .rgActiveRow td, .RadGrid_Office2010Blue .rgHoveredRow td, .RadGrid_Office2010Blue .rgEditRow td {
padding-left: 8px; }
.RadGrid_Office2010Blue .rgSelectedRow td {
border-bottom-color: #7ba0cd;
}
.RadGrid_Office2010Blue .rgActiveRow td, .RadGrid_Office2010Blue .rgHoveredRow td, .RadGrid_Office2010Blue .rgEditRow td {
border-bottom-color: #d0d7e5; }
.RadGrid_Office2010Blue .rgDrag {
background-image: url('Grid/rgDrag.gif'); }
.RadGrid_Office2010Blue .rgFooterDiv, .RadGrid_Office2010Blue .rgFooter, .RadGrid_Office2010Blue .rgFooterWrapper {
background: #bbcee4 0 -6500px repeat-x url('Grid/sprite.png'); }
.RadGrid_Office2010Blue .rgFooter td, .RadGrid_Office2010Blue .rgFooterWrapper {
border-width: 1px 0 0;
border-color: #8ba0bc #fff #fff;
padding-left: 8px; }
.RadGrid_Office2010Blue .rgPager .rgStatus {
border: 1px solid;
border-width: 1px 1px 0 0;
border-color: #8ba0bc; }
.RadGrid_Office2010Blue .rgStatus div {
background-image: url('Common/loading_small.gif'); }
.RadGrid_Office2010Blue .rgPager {
background: #b4c5d9 0 -6999px repeat-x url('Grid/sprite.png');
color: #384e73; }
.RadGrid_Office2010Blue td.rgPagerCell {
border-top: 1px solid #8ba0bc;
border-left: 1px solid #f5faff; }
.RadGrid_Office2010Blue .rgPageFirst {
margin: 0 3px 0 0;
background-position: 0 -550px; }
.RadGrid_Office2010Blue .rgPageFirst:hover {
background-position: 0 -600px; }
.RadGrid_Office2010Blue .rgPagePrev {
margin: 0 3px 0 0;
background-position: 0 -700px; }
.RadGrid_Office2010Blue .rgPagePrev:hover {
background-position: 0 -750px; }
.RadGrid_Office2010Blue .rgPageNext {
margin: 0 0 0 3px;
background-position: 0 -850px; }
.RadGrid_Office2010Blue .rgPageNext:hover {
background-position: 0 -900px; }
.RadGrid_Office2010Blue .rgPageLast {
margin: 0 0 0 3px;
background-position: 0 -1000px; }
.RadGrid_Office2010Blue .rgPageLast:hover {
background-position: 0 -1050px; }
.RadGrid_Office2010Blue .rgPager .rgPagerButton {
border-color: #7793b9;
background: #e8f1fc repeat-x 0 -1550px url('Grid/sprite.png');
color: #00156e;
font: normal 12px "Segoe UI", Arial, Helvetica, sans-serif;
line-height: 12px; }
.RadGrid_Office2010Blue .rgNumPart a {
color: #384e73; }
.RadGrid_Office2010Blue .rgNumPart a:hover, .RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage {
background: no-repeat url('Grid/sprite.png'); }
.RadGrid_Office2010Blue .rgNumPart a:hover span, .RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage span {
background: no-repeat url('Grid/sprite.png'); }
.RadGrid_Office2010Blue .rgNumPart a:hover {
background-position: 100% -1250px;
color: #1e395b; }
.RadGrid_Office2010Blue .rgNumPart a:hover span {
background-position: 0 -1150px; }
.RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage {
background-position: 100% -1450px;
color: #384e73; }
.RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage:hover {
background-position: 100% -1450px;
color: #384e73; }
.RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage span, .RadGrid_Office2010Blue .rgNumPart a.rgCurrentPage:hover span {
background-position: 0 -1350px; }
.RadGrid_Office2010Blue .rgHeader .rgSortAsc {
background-position: 3px -147px;
height: 10px; }
.RadGrid_Office2010Blue .rgHeader .rgSortDesc {
background-position: 3px -197px;
height: 10px; }
/*footer*/
/*status*/
/*pager*/
/*sorting, reordering*/
.GridReorderTop_Office2010Blue {
height: 12px;
background: 0 0 no-repeat url('Grid/sprite.png'); }
.GridReorderBottom_Office2010Blue {
height: 12px;
background: 0 0 no-repeat url('Grid/sprite.png');
background-position: 0 -50px; }
/*filtering*/
.RadGrid_Office2010Blue .rgFilterRow {
background: #dae7f5; }
.RadGrid_Office2010Blue .rgFilterRow td {
border-style: solid;
border-color: #8ba0bc;
border-width: 0 0 1px 1px; }
.RadGrid_Office2010Blue .rgFilter {
background-position: 0 -300px; }
.RadGrid_Office2010Blue .rgFilter:hover {
background-position: 0 -350px; }
.RadGrid_Office2010Blue .rgFilterActive {
background-position: 0 -400px; }
.RadGrid_Office2010Blue .rgFilterActive:hover {
background-position: 0 -400px; }
.RadGrid_Office2010Blue .rgFilterBox {
border-color: #9babc2;
font: normal 12px "Segoe UI", Arial, Helvetica, sans-serif;
color: #000; }
/*filter context menu*/
.RadMenu_Office2010Blue .rgHCMClear, .RadMenu_Office2010Blue .rgHCMFilter {
border-color: #a7bedb #7d98bd #a3bad8;
background: #e8f1fc center -23px repeat-x url('FormDecorator/ButtonSprites.gif');
color: #00156e;
font-family: "segoe ui",arial,sans-serif; }
.RadMenu_Office2010Blue .rgHCMClear:hover, .RadMenu_Office2010Blue .rgHCMFilter:hover {
border-color: #d8ca95 #b9a073 #c6ba9d;
background-position: center -67px;
background-color: #ffe18a;
color: #000; }
/*context menu*/
.GridContextMenu_Office2010Blue .rmLeftImage {
background-image: url('../Common/Grid/contextMenu.gif'); }
.GridContextMenu_Office2010Blue .rgHCMSortAsc .rmLeftImage {
background-position: 0 0; }
.GridContextMenu_Office2010Blue .rgHCMSortDesc .rmLeftImage {
background-position: 0 -40px; }
.GridContextMenu_Office2010Blue .rgHCMUnsort .rmLeftImage {
background-position: 0 -80px; }
.GridContextMenu_Office2010Blue .rgHCMGroup .rmLeftImage {
background-position: 0 -120px; }
.GridContextMenu_Office2010Blue .rgHCMUngroup .rmLeftImage {
background-position: 0 -160px; }
.GridContextMenu_Office2010Blue .rgHCMCols .rmLeftImage {
background-position: 0 -200px; }
.GridContextMenu_Office2010Blue .rgHCMFilter .rmLeftImage {
background-position: 0 -240px; }
.GridContextMenu_Office2010Blue .rgHCMUnfilter .rmLeftImage {
background-position: 0 -280px; }
/*grouping*/
.RadGrid_Office2010Blue .rgGroupPanel {
border: 0 solid #8ba0bc;
border-bottom-width: 1px;
background: #dae7f5; }
.RadGrid_Office2010Blue .rgGroupPanel td {
border: 0;
padding: 3px 4px;
vertical-align: middle; }
.RadGrid_Office2010Blue .rgGroupPanel td td {
padding: 0; }
.RadGrid_Office2010Blue .rgGroupPanel .rgSortAsc {
background-position: 4px -144px; }
.RadGrid_Office2010Blue .rgGroupPanel .rgSortDesc {
background-position: 4px -194px; }
.RadGrid_Office2010Blue .rgUngroup {
background-position: 0 -7500px; }
.RadGrid_Office2010Blue .rgGroupItem {
border: 1px solid #7793b9;
background: #e8f1fc repeat-x 0 -1550px url('Grid/sprite.png');
color: #00156e; }
.RadGrid_Office2010Blue .rgGroupHeader {
background: #dae7f5;
font-size: 1.1em;
line-height: 21px;
color: #384e73; }
.RadGrid_Office2010Blue .rgGroupHeader td {
border-bottom: 1px solid #dadcdd;
padding-left: 8px; }
.RadGrid_Office2010Blue td.rgGroupCol, .RadGrid_Office2010Blue td.rgExpandCol {
background: #dae7f5;
border-color: #dae7f5; }
.RadGrid_Office2010Blue .rgGroupHeader .rgExpand {
background-position: 5px -495px; }
.RadGrid_Office2010Blue .rgGroupHeader .rgCollapse {
background-position: 3px -93px; }
.RadGrid_Office2010Blue .rgEditForm {
border-bottom: 1px solid #8ba0bc; }
.RadGrid_Office2010Blue .rgUpdate {
background-position: 0 -1800px; }
.RadGrid_Office2010Blue .rgCancel {
background-position: 0 -1850px; }
.RadGrid_Office2010Blue .rgCommandRow .rgCancel {
background-position: 3px -1877px; }
.RadGrid_Office2010Blue .rgDetailTable {
border-color: #688caf; }
.RadGrid_Office2010Blue .rgExpand {
background-position: 5px -496px; }
.RadGrid_Office2010Blue .rgCollapse {
background-position: 3px -94px; }
.RadGrid_Office2010Blue .rgCommandRow {
background: #bdcbde 0 -2100px repeat-x url('Grid/sprite.png');
color: #333; }
.RadGrid_Office2010Blue .rgCommandCell {
border: 0;
padding: 0; }
.RadGrid_Office2010Blue thead .rgCommandCell {
border-bottom: 1px solid #8ba0bc; }
.RadGrid_Office2010Blue .rgCommandTable td {
border: 0;
padding: 2px 7px; }
.RadGrid_Office2010Blue .rgCommandRow a {
color: #242424;
text-decoration: none; }
.RadGrid_Office2010Blue .rgAdd {
margin-right: 3px;
background-position: 0 -1650px; }
.RadGrid_Office2010Blue .rgSave {
background-position: 3px -1825px; }
.RadGrid_Office2010Blue .rgRefresh {
margin-right: 3px;
background-position: 0 -1600px; }
.RadGrid_Office2010Blue .rgEdit {
background-position: 0 -1700px; }
.RadGrid_Office2010Blue .rgDel {
background-position: 0 -1750px; }
.RadGrid_Office2010Blue .rgExpXLS, .RadGrid_Office2010Blue .rgExpDOC, .RadGrid_Office2010Blue .rgExpPDF, .RadGrid_Office2010Blue .rgExpCSV {
background-image: url('../Common/Grid/export.gif'); }
.RadGrid_Office2010Blue .rgExpXLS {
background-position: 0 0; }
.RadGrid_Office2010Blue .rgExpDOC {
background-position: 0 -50px; }
.RadGrid_Office2010Blue .rgExpPDF {
background-position: 0 -100px; }
.RadGrid_Office2010Blue .rgExpCSV {
background-position: 0 -150px; }
/*editing*/
/*hierarchy*/
/*command row*/
/*multirow select*/
.rgCellSelectorArea_Office2010Blue, .GridRowSelector_Office2010Blue {
background: #00156e; }
/*row drag n drop*/
.GridItemDropIndicator_Office2010Blue {
border-top: 1px dashed #00156e; }
/*tooltip*/
.GridToolTip_Office2010Blue {
border: 1px solid #6187b8;
padding: 3px;
background: #d7e3f2;
color: #333; }
/*rtl*/
.RadGridRTL_Office2010Blue .rgHeader:first-child, .RadGridRTL_Office2010Blue th.rgResizeCol:first-child, .RadGridRTL_Office2010Blue .rgFilterRow > td:first-child, .RadGridRTL_Office2010Blue .rgRow > td:first-child, .RadGridRTL_Office2010Blue .rgAltRow > td:first-child {
border-left-width: 1px;
padding-left: 7px; }
.RadGridRTL_Office2010Blue .rgPageFirst {
background-position: 0 -1000px; }
.RadGridRTL_Office2010Blue .rgPageFirst:hover {
background-position: 0 -1050px; }
.RadGridRTL_Office2010Blue .rgPagePrev {
margin: 0 0 0 3px;
background-position: 0 -850px; }
.RadGridRTL_Office2010Blue .rgPagePrev:hover {
background-position: 0 -900px; }
.RadGridRTL_Office2010Blue .rgPageNext {
margin: 0 3px 0 0;
background-position: 0 -700px; }
.RadGridRTL_Office2010Blue .rgPageNext:hover {
background-position: 0 -750px; }
.RadGridRTL_Office2010Blue .rgPageLast {
background-position: 0 -550px; }
.RadGridRTL_Office2010Blue .rgPageLast:hover {
background-position: 0 -600px; }
.RadGridRTL_Office2010Blue .rgGroupHeader .rgExpand {
background-position: -20px -495px; }
.RadGridRTL_Office2010Blue .rgExpand {
background-position: -20px -496px; }
.RadGridRTL_Office2010Blue .rgGroupHeader .rgCollapse {
background-position: -20px -93px; }
/*
body * {
font-family: "Lucida Sans" ;
color: black;
}
*/
Hi,
I have been trying to solve this issue for three days now and it is driving me nuts.
I am sure it is just a setting that I have not set or something I have forgot to do so here I am looking for any help I can get.
Environment
Visual Studio 2010 ultimate
SQL 2008 Enterprise
asp.net
.net 4.0
Telerik.Web.UI, v2013.1.403.40
OK here is the scenario.
Add an appointment to RadScheduler and it works fine, you can carry out all the functions and RadScheduler handles the data fine. It shows appointments in the correct time slots and right dates.
If you look in the SQL Database at the data the Start and End dates and times do not match what RadScheduler shows.
If you enter an appointment before 9 am it shows with the date of the previous day. After 9 am has correct date but wrong time. None of the appoints have the correct times.
I have checked my Regional settings, set the correct TimeZoneID in RadScheduler and am now at my wits end.
The only reason I am worrying about it is that i need to access the data in the SQL database from another function and I cant gather the correct appointments by date or times as none of them match what's in the SQL Database.
I have attached some screen shots that better show the process and matching data. I have only a single appointment to help keep it simple.
I put a debug message in the RadScheduler Insert and Update appointment and this is the data I captured
This was for the 9 am appointment image (SQL1)
Update Start Time= 14/04/2014 11:30:00 PM
Update End Time 15/04/2014
Update Time Zone= E. Australia Standard Time
Update Duration= 00:30:00
This was for the 9:30 am appointment image (SQL2)
Update Start Time= 14/04/2014 11:00:00 PM
Update End Time 14/04/2014 11:30:00 PM
Update Time Zone= E. Australia Standard Time
Update Duration= 00:30:00
This is the 10 am appointment (SQL3)
Update Start Time= 14/04/2014 11:30:00 PM
Update End Time 15/04/2014
Update Time Zone= E. Australia Standard Time
Update Duration= 00:30:00
ASPX
____________________________________________________________________________________________________________
<telerik:RadScheduler ID="QuoteScheduler" runat="server"
OnClientDataBound="OnClientDataBound"
DataDescriptionField="Description" DataEndField="End" DataKeyField="ID"
DataRecurrenceField="RecurrenceRule"
DataRecurrenceParentKeyField="RecurrenceParentID"
DataReminderField="Reminder" DataStartField="Start"
DataSubjectField="Subject" Height="587px" Skin="Office2010Black"
TimeZoneID="E. Australia Standard Time" TimeZoneOffset="10:00:00"
DataSourceID="QuoteAppointSQL" RowHeight="22px"
StartInsertingInAdvancedForm="True" EnableTheming="True"
Font-Names="Calibri" Font-Size="Small" EditFormTimeFormat="hh:mm" HoursPanelTimeFormat="htt"
FirstDayOfWeek="Monday" LastDayOfWeek="Sunday" DayStartTime="04:30:00" DayEndTime="19:00:00"
WorkDayStartTime="04:30:00" WorkDayEndTime="19:00:00" EnableCustomAttributeEditing="True">
<ExportSettings FileName="Quote Appointments.pdf">
<Pdf PageHeight="297mm" PageWidth="210mm" PaperSize="A4" Producer="mrConcrete" />
</ExportSettings>
<AdvancedForm Modal="True" TimeFormat="hh:mm" EnableCustomAttributeEditing="True" />
<ResourceTypes>
<telerik:ResourceType DataSourceID="ResourceSQL" ForeignKeyField="UserID" KeyField="ID" Name="AdminUser" TextField= "FullName" />
</ResourceTypes>
<Localization AdvancedSubject="Appointment Subject" Save="Save Appointment" />
<TimelineView ColumnHeaderDateFormat="ddd-MM" HeaderDateFormat="ddd-MM" />
<DayView DayStartTime="04:00:00" WorkDayEndTime="19:00:00" WorkDayStartTime="04:00:00" />
<MonthView HeaderDateFormat="MMMM, yyyy" />
</telerik:RadScheduler>
________________________________________________________________________________________________________________
Code Behind in FormCreate
If e.Container.Mode <> SchedulerFormMode.Insert AndAlso e.Container.Mode <> SchedulerFormMode.Edit Then
Dim Combo As RadComboBox = TryCast(e.Container.FindControl("ResAdminUser"), RadComboBox)
FindName = GetData("Select FirstName from Users where ID=" & Me.UserNum.Text)
FindName = FindName & " " & GetData("Select Surname from Users where ID=" & Me.UserNum.Text)
If Combo.Text <= "" Then Combo.SelectedIndex = Combo.FindItemIndexByText(FindName)
Dim StartDate As RadDatePicker = TryCast(e.Container.FindControl("StartDate"), RadDatePicker)
StartDate.SelectedDate = Today
Dim StartTime As RadTimePicker = TryCast(e.Container.FindControl("StartTime"), RadTimePicker)
StartTime.TimeView.Interval = New TimeSpan(0, 30, 0)
StartTime.TimeView.TimeFormat = "hh:mm tt"
StartTime.TimeView.StartTime = TimeSpan.FromHours("4.00")
StartTime.TimeView.EndTime = TimeSpan.FromHours("18.00")
StartTime.TimeView.Columns = 4
StartTime.TimeView.HeaderText = "Start Time For " & FindName
startTime.TimeView.DataList.DataSource = Nothing
startTime.DataBind()
Dim EndTime As RadTimePicker = TryCast(e.Container.FindControl("EndTime"), RadTimePicker)
EndTime.TimeView.Interval = New TimeSpan(0, 30, 0)
EndTime.TimeView.TimeFormat = "hh:mm tt"
EndTime.TimeView.StartTime = TimeSpan.FromHours("04.00")
EndTime.TimeView.EndTime = TimeSpan.FromHours("19.00")
EndTime.TimeView.Columns = 4
EndTime.TimeView.HeaderText = "End Time For " & FindName
EndTime.TimeView.DataList.DataSource = Nothing
EndTime.DataBind()
End If
end if
I am not sure what else I can supply but I hope this enough for somebody much smarter then me to point me in the right direction of give me some hints and what I am doing wrong.
Thanks in advance
chris
<
telerik:RadScriptManager
runat
=
"server"
ID
=
"RadScriptManager1"
/>
<
telerik:RadAjaxPanel
runat
=
"server"
ID
=
"RadAjaxPanel1"
>
<
telerik:RadListBox
runat
=
"server"
ID
=
"SavedChangesList"
Width
=
"600px"
Height
=
"200px"
Visible
=
"false"
></
telerik:RadListBox
>
<
telerik:RadGrid
ID
=
"RadGrid1"
GridLines
=
"None"
runat
=
"server"
AllowAutomaticDeletes
=
"True"
AllowAutomaticInserts
=
"True"
PageSize
=
"10"
Skin
=
"Default"
OnItemDeleted
=
"RadGrid1_ItemDeleted"
OnItemInserted
=
"RadGrid1_ItemInserted"
OnItemUpdated
=
"RadGrid1_ItemUpdated"
OnPreRender
=
"RadGrid1_PreRender"
AllowAutomaticUpdates
=
"True"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
Width
=
"950px"
OnBatchEditCommand
=
"RadGrid1_BatchEditCommand"
DataSourceID
=
"sqlContractMatrix"
>
<
MasterTableView
CommandItemDisplay
=
"TopAndBottom"
DataKeyNames
=
"ID"
DataSourceID
=
"sqlContractMatrix"
HorizontalAlign
=
"NotSet"
EditMode
=
"Batch"
AutoGenerateColumns
=
"False"
>
<
BatchEditingSettings
EditType
=
"Cell"
/>
<
SortExpressions
>
<
telerik:GridSortExpression
FieldName
=
"SiteID,ProductID"
SortOrder
=
"Descending"
/>
</
SortExpressions
>
<
Columns
>
<
telerik:GridTemplateColumn
HeaderText
=
"Site"
HeaderStyle-Width
=
"150px"
UniqueName
=
"SiteID"
DataField
=
"SiteID"
>
<
ItemTemplate
>
<%# Eval("SiteName") %>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadDropDownList
runat
=
"server"
ID
=
"ddlSites"
AppendDataBoundItems
=
"true"
DataValueField
=
"SiteID"
DataTextField
=
"SiteName"
DataSourceID
=
"sqlSites"
>
</
telerik:RadDropDownList
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Product"
HeaderStyle-Width
=
"150px"
UniqueName
=
"ProductID"
DataField
=
"ProductID"
>
<
ItemTemplate
>
<%# Eval("ProductName") %>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadDropDownList
runat
=
"server"
ID
=
"ddlProducts"
DropDownWidth
=
"250"
DropDownHeight
=
"400"
DefaultMessage
=
"Product"
AppendDataBoundItems
=
"true"
DataValueField
=
"ProductID"
DataTextField
=
"ProductName"
DataSourceID
=
"sqlProducts"
>
</
telerik:RadDropDownList
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"TemplateFile"
HeaderStyle-Width
=
"200px"
HeaderText
=
"Template"
SortExpression
=
"TemplateFile"
UniqueName
=
"TemplateFile"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PDFName"
HeaderStyle-Width
=
"200px"
HeaderText
=
"PDFName"
SortExpression
=
"PDFName"
UniqueName
=
"PDFName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridButtonColumn
ConfirmText
=
"Delete this record?"
ConfirmDialogType
=
"RadWindow"
ConfirmTitle
=
"Delete"
HeaderText
=
"Delete"
HeaderStyle-Width
=
"50px"
ButtonType
=
"ImageButton"
CommandName
=
"Delete"
Text
=
"Delete"
UniqueName
=
"DeleteColumn"
>
</
telerik:GridButtonColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
<
asp:SqlDataSource
ID
=
"sqlContractMatrix"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:FitTrack %>"
DeleteCommand="DELETE FROM ContractMatrix WHERE ID = @ID"
InsertCommand="INSERT INTO ContractMatrix (SiteID, ProductID, TemplateFile, PDFName, LastModifiedDate, LastModifiedByID) VALUES (@SiteID, @ProductID, @TemplateFile, @PDFName, @LastModifiedDate, @LastModifiedByID)"
UpdateCommand="UPDATE ContractMatrix SET SiteID = @SiteID, ProductID = @ProductID, TemplateFile = @TemplateFile, PDFName = @PDFName, LastModifiedDate = GETDATE(), LastModifiedByID = @LastModifiedByID WHERE ID = @ID">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
></
asp:Parameter
>
</
DeleteParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"SiteID"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"ProductID"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"TemplateFile"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"PDFName"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"LastModifiedDate"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"LastModifiedByID"
Type
=
"DateTime"
></
asp:Parameter
>
</
InsertParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"SiteID"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"ProductID"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"TemplateFile"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"PDFName"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"LastModifiedDate"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"LastModifiedByID"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
></
asp:Parameter
>
</
UpdateParameters
>
</
asp:SqlDataSource
>
<!-- SQL data sources for various lookup tables -->
<
asp:SqlDataSource
ID
=
"sqlSites"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:FitTrack %>" ProviderName="System.Data.SqlClient" SelectCommand="..."></
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"sqlProducts"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:FitTrack %>" ProviderName="System.Data.SqlClient"></
asp:SqlDataSource
>