or
'a holder for the current month
Dim
currentMonth =
""
'a holder for the count
Dim
count = -1
Dim
rangeTable
As
New
DataTable
rangeTable.Columns.Add(
"Label"
)
rangeTable.Columns.Add(
"Position"
)
rangeTable.Columns.Add(
"Value"
)
Using myconn
As
New
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings(
"connection"
).ToString)
myconn.Open()
Dim
cmd =
New
SqlCommand(sql, myconn)
Dim
reader = cmd.ExecuteReader()
While
reader.Read()
'if the currentMonth is new, then we add it to the data table for a range
If
Not
(currentMonth = (Format(reader(
"DateHour"
),
"MMMM"
)))
Then
currentMonth = Format(reader(
"DateHour"
),
"MMMM"
)
count = count + 1
End
If
rangeTable.Rows.Add(currentMonth, count, reader(
"PointAverage"
))
'Dim tempSeries As New ChartSeries
'tempSeries.SetValues(1, 2)
'chart.Series.Add(tempSeries)
End
While
myconn.Close()
End
Using
'using myconn
'add the range
chart.PlotArea.XAxis.AddRange(0, count, 1)
For
Each
i
As
DataRow
In
rangeTable.Rows
chart.PlotArea.XAxis(i(
"Position"
)).TextBlock.Text = i(
"Label"
)
Dim
tempSeries
As
New
ChartSeries
tempSeries.SetValues(i(
"Position"
), i(
"Value"
))
chart.Series.Add(tempSeries)
Next
<
script
type
=
"text/javascript"
>
function GetRadWindow() {
var oWindow = null;
if (window.radWindow) oWindow = window.radWindow;
else if (window.frameElement.radWindow) oWindow = window.frameElement.radWindow;
return oWindow;
}
function CloseDialog() {
GetRadWindow().close();
}
</
script
>
<
asp:Button
ID
=
"Button1"
runat
=
"server"
Text
=
"Soumettre ce ticket"
onclick
=
"Button1_Click"
OnClientClick
=
"CloseDialog()"
/>
<
input
type
=
"submit"
id
=
"Button1"
onclick
=
"CloseDialog();"
value
=
"Soumettre ce ticket"
name
=
"Button1"
/>
<
p
><
strong
>Lorem ipsum dolor sit amet, consectetur <
br
/>
Lorem ipsum dolor sit amet, consectetur <
br
/>
Lorem ipsum dolor sit amet, consectetur </
strong
></
p
>
<
p
>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ultricies dignissim diam, sed vestibulum metus semper sed. Nullam cursusLorem ipsum dolor sit amet, consectetur. </
p
>
<
p
>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ultricies dignissim diam, sed vestibulum metus semper sed. Nullam . <
br
/>
<
br
/>
<
strong
>Lorem ipsum</
strong
> <
br
/>
<
br
/>
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ultricies dignissim diam, sed vestibulum metus semper sed. Nullam cursusLorem ipsum dolor sit amet, consectetur </
p
>
<
p
>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ultricies dignissim diam, sed vestibulum metus semper sed. Nullam cursus. </
p
>
<
p
><
strong
>Lorem ipsum :</
strong
> </
p
>
<
ul
>
<
li
>Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur (optional) </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>A Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur </
li
>
<
li
>Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur </
li
>
</
ul
>
<
p
> </
p
>
<!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
>
<
style
type
=
"text/css"
>
html, body, form
{
margin: 0px;
padding: 0px;
width: 100%;
height: 100%;
overflow: hidden;
color: #555555;
}
.left-scroll, .pane-scroller
{
outline: none !important;
}
.jspContainer
{
overflow: hidden;
position: relative;
}
.jspPane
{
position: absolute;
}
.jspVerticalBar
{
position: absolute;
top: 0;
right: 0;
width: 16px;
height: 100%;
border: 1px solid #999;
border-right: 0px;
}
.jspHorizontalBar
{
position: absolute;
bottom: 0;
left: 0;
width: 100%;
height: 16px;
}
.jspVerticalBar *, .jspHorizontalBar *
{
margin: 0;
padding: 0;
}
.jspCap
{
display: none;
}
.jspHorizontalBar .jspCap
{
float: left;
}
.jspTrack
{
background: #fff;
position: relative;
border-top: 1px solid #999;
border-bottom: 1px solid #999;
}
.jspDrag
{
background: #666;
background: #8DBB40;
position: relative;
top: 0;
left: 0;
cursor: pointer;
border-top: 1px solid #999;
border-bottom: 1px solid #999;
}
.jspHorizontalBar .jspTrack, .jspHorizontalBar .jspDrag
{
float: left;
height: 100%;
}
.jspArrow
{
background: #50506d;
text-indent: -20000px;
display: block;
cursor: pointer;
}
.jspArrow.jspDisabled
{
cursor: default;
background: #80808d;
}
.jspVerticalBar .jspArrow
{
height: 16px;
}
.jspHorizontalBar .jspArrow
{
width: 16px;
float: left;
height: 100%;
}
.jspVerticalBar .jspArrow:focus
{
outline: none;
}
.jspCorner
{
background: #eeeef4;
float: left;
height: 100%;
}
/* Yuk! CSS Hack for IE6 3 pixel bug :( */
* html .jspCorner
{
margin: 0 -3px 0 0;
}
.jspArrowUp, .jspArrowUp.jspDisabled
{
background-color: #c0c0c0;
background-image: url('http://jscrollpane.kelvinluck.com/themes/lozenge/image/ui-icons_222222_256x240.png');
background-position: 1px 0px !important;
}
.jspArrowDown, .jspArrowDown.jspDisabled
{
padding-bottom: 2px;
background-color: #c0c0c0;
background-image: url('http://jscrollpane.kelvinluck.com/themes/lozenge/image/ui-icons_222222_256x240.png');
background-position: -64px 0 !important;
}
.jspArrowLeft, .jspArrowLeft.jspDisabled
{
background-color: #c0c0c0;
background-image: url('http://jscrollpane.kelvinluck.com/themes/lozenge/image/ui-icons_222222_256x240.png');
background-position: -96px 0 !important;
}
.jspArrowRight, .jspArrowRight.jspDisabled
{
background-color: #c0c0c0;
background-image: url('http://jscrollpane.kelvinluck.com/themes/lozenge/image/ui-icons_222222_256x240.png');
background-position: -32px 0 !important;
}
</
style
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"TestRadScriptManager"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
div
class
=
"pane-scroller"
style
=
"width: 100%; height: 100px;"
>
<
telerik:RadTextBox
ID
=
"tbRetypePassword"
runat
=
"server"
Width
=
"200px"
>
</
telerik:RadTextBox
>
<
asp:TextBox
ID
=
"TextBox1"
runat
=
"server"
Text
=
"aasaasasd"
></
asp:TextBox
>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
</
div
>
<
div
class
=
"pane-scroller"
style
=
"width: 100%; height: 500px;"
>
<
telerik:RadTextBox
ID
=
"RadTextBox1"
runat
=
"server"
Width
=
"200px"
>
</
telerik:RadTextBox
>
<
asp:TextBox
ID
=
"TextBox2"
runat
=
"server"
Text
=
"aasaasasd"
></
asp:TextBox
>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
<
br
/>
</
div
>
<
script
type
=
"text/javascript"
src
=
"http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"
></
script
>
<
script
type
=
"text/javascript"
src
=
"http://jscrollpane.kelvinluck.com/script/jquery.mousewheel.js"
></
script
>
<
script
type
=
"text/javascript"
src
=
"http://jscrollpane.kelvinluck.com/script/jquery.jscrollpane.min.js"
></
script
>
<
script
type
=
"text/javascript"
>
jQuery(document).ready(function ($) {
ReloadScroller();
});
function ReloadScroller() {
$(function () {
$('.pane-scroller').jScrollPane(
{
showArrows: true,
horizontalGutter: 10
}
);
});
}
</
script
>
</
form
>
</
body
>
</
html
>
<
telerik:RadGrid
ID
=
"grdContentManagement"
runat
=
"server"
SkinID
=
"StaticColumnsNoPagingBuiltInSorting"
OnItemCommand
=
"ContentManagementGridItemCommand"
OnNeedDataSource
=
"grdContentManagement_NeedDataSource"
OnItemDataBound
=
"grdContentManagement_OnItemDataBound"
CellSpacing
=
"0"
GridLines
=
"None"
AllowSorting
=
"True"
AllowPaging
=
"True"
PageSize
=
"15"
Height
=
"478"
ShowFooter
=
"false"
>
<
MasterTableView
DataKeyNames
=
"Id"
ClientDataKeyNames
=
"Id"
AllowSorting
=
"true"
>
<
Columns
>
<
telerik:GridTemplateColumn
UniqueName
=
"Selected"
HeaderText
=
"Display"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"50px"
ItemStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
asp:CheckBox
ID
=
"chkSelected"
runat
=
"server"
onclick
=
"CheckBoxClicked(this)"
/>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Property"
UniqueName
=
"PropertyName"
DataField
=
"PropertyName"
SortExpression
=
"PropertyName"
HeaderStyle-Width
=
"200px"
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
UniqueName
=
"DisplayName"
HeaderText
=
"Label"
HeaderStyle-Width
=
"200px"
SortExpression
=
"DisplayName"
>
<
ItemTemplate
>
<
telerik:RadTextBox
ID
=
"txtDisplayName"
runat
=
"server"
MaxLength
=
"255"
Width
=
"100%"
/>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Data Type"
DataField
=
"DataType"
SortExpression
=
"DataType"
HeaderStyle-Width
=
"100px"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Object Type"
DataField
=
"ObjectType"
SortExpression
=
"ObjectType"
/>
<
telerik:GridBoundColumn
DataField
=
"Id"
SortExpression
=
"Id"
Visible
=
"false"
/>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
>
</
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"True"
/>
<
Scrolling
UseStaticHeaders
=
"False"
/>
<
Resizing
EnableRealTimeResize
=
"true"
/>
</
ClientSettings
>
<
FilterMenu
EnableImageSprites
=
"False"
>
<
WebServiceSettings
>
<
ODataSettings
InitialContainerName
=
""
>
</
ODataSettings
>
</
WebServiceSettings
>
</
FilterMenu
>
</
telerik:RadGrid
>
protected
void
grdContentManagement_OnItemDataBound(
object
sender, GridItemEventArgs e)
{
GridDataItem item = e.Item
as
GridDataItem;
if
(item !=
null
)
{
TelerikGridHelper.SetGridToolTips(item
as
GridDataItem);
TelerikGridHelper.SetGridHtmlEncode(item
as
GridDataItem);
CheckBox chkBox = (CheckBox)item[
"Selected"
].Controls[1];
chkBox.Checked = ((ContentManagementFieldForDisplay)(item.DataItem)).Selected;
chkBox.Attributes.Add(
"rowIndex"
, item.ItemIndex.ToString());
RadTextBox txtBox = (RadTextBox)item[
"DisplayName"
].Controls[1];
txtBox.Text = ((ContentManagementFieldForDisplay)(item.DataItem)).DisplayName;
}
}
function
CheckBoxClicked(checkBox) {
if
(checkBox.checked) {
//enable the textbox
}
else
{
//disable the textbox
}
}
<
telerik:RadAsyncUpload
ID
=
"RadUploadAlertDocuments"
runat
=
"server"
AutoAddFileInputs
=
"true"
MaxFileSize
=
"2147483647"
MultipleFileSelection
=
"Automatic"
InputSize
=
"70"
>
</
telerik:RadAsyncUpload
>