or
<
div
style
=
"width: 98%; margin: 0 auto; overflow: auto; border: 1px solid green;"
>
<
div
id
=
"slide_00"
class
=
"slide"
style
=
"border: 1px solid red; height: 250px; width: 350px;"
>
<
telerik:RadHtmlChart
runat
=
"server"
Width
=
"350px"
Height
=
"225px"
ID
=
"RadHtmlChart1"
DataSourceID
=
"SqlDataSource1"
>
<
PlotArea
>
<
Series
>
<
telerik:ColumnSeries
DataFieldY
=
"NumOfMembers"
>
<
TooltipsAppearance
Color
=
"White"
/>
</
telerik:ColumnSeries
>
</
Series
>
<
XAxis
DataLabelsField
=
"MemberType"
>
<
TitleAppearance
Text
=
"Member Types"
>
<
TextStyle
Margin
=
"5"
/>
</
TitleAppearance
>
<
MajorGridLines
Visible
=
"false"
/>
<
MinorGridLines
Visible
=
"false"
/>
</
XAxis
>
<
YAxis
>
<
TitleAppearance
Text
=
"Active Members"
>
<
TextStyle
Margin
=
"5"
/>
</
TitleAppearance
>
<
MinorGridLines
Visible
=
"false"
/>
</
YAxis
>
</
PlotArea
>
<
ChartTitle
Text
=
"# of Active ASI Credit Unions"
>
</
ChartTitle
>
</
telerik:RadHtmlChart
>
</
div
>
<
div
id
=
"slide_01"
class
=
"slide"
style
=
"border: 1px solid red; height: 250px; width: 350px;"
">
<
telerik:RadHtmlChart
runat
=
"server"
Width
=
"350px"
Height
=
"225px"
ID
=
"RadHtmlChart2"
DataSourceID
=
"SqlDataSource2"
>
<
PlotArea
>
<
Series
>
<
telerik:ColumnSeries
DataFieldY
=
"TotCount"
>
<
TooltipsAppearance
Color
=
"White"
/>
</
telerik:ColumnSeries
>
</
Series
>
<
XAxis
DataLabelsField
=
"Coverage"
>
<
TitleAppearance
Text
=
"Member Types"
>
<
TextStyle
Margin
=
"5"
/>
</
TitleAppearance
>
<
MajorGridLines
Visible
=
"false"
/>
<
MinorGridLines
Visible
=
"false"
/>
</
XAxis
>
<
YAxis
>
<
TitleAppearance
Text
=
"# of Financials"
>
<
TextStyle
Margin
=
"5"
/>
</
TitleAppearance
>
<
MinorGridLines
Visible
=
"false"
/>
</
YAxis
>
</
PlotArea
>
<
ChartTitle
Text
=
"Recent Qtr Financial Statements"
>
</
ChartTitle
>
</
telerik:RadHtmlChart
>
</
div
>
<
telerik:RadSlider
ID
=
"RadSlider1"
runat
=
"server"
TrackPosition
=
"TopLeft"
Value
=
"0"
ItemType
=
"Item"
Skin
=
"Black"
Width
=
"350px"
Height
=
"40px"
OnClientValueChanged
=
"UpdateVisibleSlide"
OnClientLoad
=
"UpdateVisibleSlide"
>
<
Items
>
<
telerik:RadSliderItem
Text
=
"# of Active ASI Credit Unions"
></
telerik:RadSliderItem
>
<
telerik:RadSliderItem
Text
=
"# of Financial Statements"
></
telerik:RadSliderItem
>
</
Items
>
</
telerik:RadSlider
>
</
div
>
<
telerik:RadAjaxManager
runat
=
"server"
ID
=
"radAjaxManager"
EnableAJAX
=
"True"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"radInspection"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"radInspection"
LoadingPanelID
=
"radlpInspection"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
runat
=
"server"
ID
=
"radlpInspection"
></
telerik:RadAjaxLoadingPanel
>
<
telerik:RadAjaxPanel
runat
=
"server"
ID
=
"radpnlInspection"
LoadingPanelID
=
"radlpInspection"
EnableAJAX
=
"True"
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"radInspection"
AllowPaging
=
"True"
AllowSorting
=
"True"
ShowHeader
=
"True"
GridLines
=
"None"
CellPadding
=
"0"
CellSpacing
=
"0"
PageSize
=
"20"
AllowFilteringByColumn
=
"True"
OnNeedDataSource
=
"radInspection_OnNeedDataSource"
OnItemCommand
=
"radInspection_OnItemCommand"
>
<
ClientSettings
AllowColumnsReorder
=
"False"
EnableRowHoverStyle
=
"True"
EnablePostBackOnRowClick
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
></
Selecting
>
<
Scrolling
UseStaticHeaders
=
"True"
></
Scrolling
>
</
ClientSettings
>
<
MasterTableView
DataKeyNames
=
"inspection_id"
AutoGenerateColumns
=
"False"
AllowMultiColumnSorting
=
"True"
EnableHeaderContextMenu
=
"True"
AllowFilteringByColumn
=
"True"
CommandItemDisplay
=
"TopAndBottom"
Height
=
"100%"
>
<
NoRecordsTemplate
>No inspections.</
NoRecordsTemplate
>
<
CommandItemSettings
ShowAddNewRecordButton
=
"False"
ShowCancelChangesButton
=
"False"
ShowSaveChangesButton
=
"False"
ShowRefreshButton
=
"True"
></
CommandItemSettings
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"inspection_id"
HeaderText
=
"ID"
AllowFiltering
=
"False"
>
<
HeaderStyle
Width
=
"1%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Right"
></
HeaderStyle
>
<
ItemStyle
Width
=
"1%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Right"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"inspection_datetime"
HeaderText
=
"Inspection Date"
EnableTimeIndependentFiltering
=
"True"
PickerType
=
"DateTimePicker"
DataFormatString
=
"{0:MM/dd/yyyy HH:mm}"
FilterControlWidth
=
"85%"
>
<
ItemStyle
Width
=
"5%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Left"
></
ItemStyle
>
<
HeaderStyle
Width
=
"5%"
></
HeaderStyle
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
DataField
=
"inspector"
HeaderText
=
"Inspector"
FilterControlWidth
=
"75%"
>
<
HeaderStyle
Width
=
"5%"
></
HeaderStyle
>
<
ItemStyle
Width
=
"5%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Left"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"division"
HeaderText
=
"Division"
FilterControlWidth
=
"75%"
>
<
HeaderStyle
Width
=
"5%"
></
HeaderStyle
>
<
ItemStyle
Width
=
"5%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Left"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"full_grade"
HeaderText
=
"Grade"
FilterControlWidth
=
"75%"
>
<
HeaderStyle
Width
=
"5%"
></
HeaderStyle
>
<
ItemStyle
Width
=
"5%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Left"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"length_description"
HeaderText
=
"Length"
FilterControlWidth
=
"75%"
>
<
HeaderStyle
Width
=
"5%"
></
HeaderStyle
>
<
ItemStyle
Width
=
"5%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Left"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridCheckBoxColumn
DataField
=
"complete"
HeaderText
=
"Completed"
AllowFiltering
=
"False"
>
<
HeaderStyle
Width
=
"2%"
HorizontalAlign
=
"Right"
></
HeaderStyle
>
<
ItemStyle
Width
=
"2%"
VerticalAlign
=
"Top"
HorizontalAlign
=
"Right"
></
ItemStyle
>
</
telerik:GridCheckBoxColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(Session[
"Key"
] !=
null
)
{
Session[
"Key"
] = -1;
}
if
(!IsPostBack)
{
LoadData();
}
}
private
void
LoadData()
{
var inspections = dal.Inspection.GetVInspectionHeaders();
radInspection.DataSource = inspections;
}
protected
void
radInspection_OnNeedDataSource(
object
sender, GridNeedDataSourceEventArgs e)
{
LoadData();
}
protected
void
radNew_OnClick(
object
sender, EventArgs e)
{
Session[
"Key"
] = -1;
Response.Redirect(
"header.aspx"
);
}
protected
void
radInspection_OnItemCommand(
object
sender, GridCommandEventArgs e)
{
if
(e.CommandName ==
"RowClick"
)
{
GridEditableItem item = e.Item
as
GridEditableItem;
if
(item ==
null
)
{
return
;
}
var key = item.GetDataKeyValue(
"inspection_id"
).ToString();
Response.Redirect(
string
.Format(
"viewinspection.aspx?id={0}"
, key));
}
}
}
<
telerik:RadGrid
ID
=
"rg"
runat
=
"server"
Skin
=
"Office2007"
AllowFilteringByColumn
=
"True"
AllowPaging
=
"True"
AllowSorting
=
"True"
GridLines
=
"None"
ShowStatusBar
=
"True"
OnNeedDataSource
=
"rg_NeedDataSource"
EnableLinqExpressions
=
"False"
PageSize
=
"20"
Width
=
"100%"
ShowGroupPanel
=
"True"
OnColumnCreated
=
"rg_ColCreated"
OnItemDataBound
=
"rg_ItemDataBound"
OnExcelMLExportRowCreated
=
"RadGrid1_ExcelMLExportRowCreated"
OnExcelMLExportStylesCreated
=
"RadGrid1_ExcelMLExportStylesCreated"
meta:resourcekey
=
"rgResource1"
>
<
GroupingSettings
ShowUnGroupButton
=
"True"
/>
<
ExportSettings
ExportOnlyData
=
"True"
IgnorePaging
=
"True"
>
<
Excel
Format
=
"ExcelML"
/>
</
ExportSettings
>
<
ClientSettings
AllowColumnsReorder
=
"True"
AllowDragToGroup
=
"True"
ColumnsReorderMethod
=
"Reorder"
ReorderColumnsOnClient
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
/>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
<
Resizing
AllowColumnResize
=
"True"
/>
<
Animation
AllowColumnReorderAnimation
=
"True"
/>
</
ClientSettings
>
<
MasterTableView
AllowMultiColumnSorting
=
"True"
ClientDataKeyNames
=
"oid"
DataKeyNames
=
"oid"
GroupLoadMode
=
"Client"
ShowFooter
=
"True"
ShowGroupFooter
=
"True"
UseAllDataFields
=
"True"
>
<
NoRecordsTemplate
>
<
div
>
Geen items gevonden.</
div
>
</
NoRecordsTemplate
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
/>
</
MasterTableView
>
<
HeaderContextMenu
CssClass
=
"GridContextMenu GridContextMenu_Office2007"
EnableImageSprites
=
"True"
>
</
HeaderContextMenu
>
</
telerik:RadGrid
>
protected void rg_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
DataTable dt = new DataTable();
if (ddlGebruikers.SelectedValue == "-2") return;
if (cbQuarter.Checked)
{
dt = getQuarterData();
}
else if (cbMonth.Checked)
{
dt = getMonthData();
}
rg.DataSource = dt;
}
protected void rg_ColCreated(object sender, GridColumnCreatedEventArgs e)
{
if (e.Column is GridBoundColumn)
{
GridBoundColumn col = (GridBoundColumn)e.Column;
if (col.UniqueName == "Q1" || col.UniqueName == "Q2" || col.UniqueName == "Q3" || col.UniqueName == "Q4")
{
col.Aggregate = GridAggregateFunction.Sum;
}
else if (col.UniqueName == "QR1" || col.UniqueName == "QR2" || col.UniqueName == "QR3" || col.UniqueName == "QR4")
{
col.Aggregate = GridAggregateFunction.Sum;
}
}
}
if (e.CommandName == RadGrid.InitInsertCommandName)
{
this._RadGrid1.MasterTableView.CommandItemSettings.ShowAddNewRecordButton = false;
this._RadGrid1.MasterTableView.ShowHeader = false;
}