or
public override string SelectedValue
{
get { return _SelectedValue; }
set { _SelectedValue = value; }
}
Radgrid.AutoGenerateColumns = true;
Radgrid.MasterTableView.AllowPaging = true;
Radgrid.MasterTableView.IsItemInserted = true;
Radgrid.ExportSettings.OpenInNewWindow = true;
Radgrid.AllowFilteringByColumn = false;
Radgrid.ExportSettings.ExportOnlyData = true;
Radgrid.ExportSettings.HideStructureColumns = true;
Radgrid.MasterTableView.HierarchyDefaultExpanded = false;
Radgrid.MasterTableView.NestedViewTemplate = null;
Radgrid.MasterTableView.HierarchyDefaultExpanded = false;
Radgrid.MasterTableView.ClearChildEditItems();
Radgrid.ExportSettings.FileName = filename;
Radgrid.ExportSettings.Excel.Format = GridExcelExportFormat.Html;
Radgrid.MasterTableView.ExportToPdf();
ClientEvents-OnDataBound
ClientEvents-OnDataBinding
ClientEvents-OnGridCreated
ClientEvents-OnGridCreating
ClientEvents-OnMasterTableViewCreated
ClientEvents-OnMasterTableViewCreating
Also, here is my code below:
function rgSchoolMonitor_OnDataBinding()
{
var grid = $find("<%=rgSchoolMonitor.ClientID %>");
var masterTableView = grid.get_masterTableView();
var pageCount = masterTableView.get_pageCount();
if (pageCount > 1)
{
//Need to Iterate Through Pages
var pageIndex = masterTableView.get_currentPageIndex();
if ((pageIndex + 1) > (pageCount - 1))
{
masterTableView.set_currentPageIndex(0);
}
else
{
masterTableView.set_currentPageIndex((pageIndex + 1));
}
}
}
<
telerik:RadPivotGrid
ID
=
"grdRACI"
runat
=
"server"
AllowFiltering
=
"False"
DataSourceID
=
"sqlRACI"
ClientSettings-Scrolling-AllowVerticalScroll
=
"false"
TotalsSettings-GrandTotalsVisibility
=
"None"
Skin
=
"Vista"
AggregatesLevel
=
"-1"
ColumnHeaderCellStyle-Width
=
"100px"
RowHeaderCellStyle-Width
=
"400px"
AggregatesPosition
=
"Columns"
OnCellDataBound
=
"grdRACI_CellDataBound"
IsFilterCommandInProgress
=
"False"
DataCellStyle-Width
=
"100px"
RowHeaderTableLayout
=
"Fixed"
ColumnHeaderTableLayout
=
"Fixed"
ShowColumnHeaderZone
=
"False"
ShowDataHeaderZone
=
"False"
ShowFilterHeaderZone
=
"False"
>
<
Fields
>
<
telerik:PivotGridRowField
DataField
=
"Task"
UniqueName
=
"column"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridColumnField
DataField
=
"RoleName"
UniqueName
=
"column1"
>
</
telerik:PivotGridColumnField
>
<
telerik:PivotGridAggregateField
DataField
=
"RACI"
Aggregate
=
"Max"
GrandTotalAggregateFormatString
=
""
UniqueName
=
"column2"
>
</
telerik:PivotGridAggregateField
>
</
Fields
>
<
TotalsSettings
GrandTotalsVisibility
=
"None"
/>
<
ConfigurationPanelSettings
Position
=
"FieldsWindow"
/>
</
telerik:RadPivotGrid
>
protected void grdRACI_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)
{
if (e.Cell is PivotGridColumnHeaderCell)
{
PivotGridColumnHeaderCell cell = e.Cell as PivotGridColumnHeaderCell;
cell.HorizontalAlign = HorizontalAlign.Center;
cell.Wrap = true;
}
if (e.Cell is PivotGridDataCell)
{
Color CFFD_Highlight = Color.Beige;
PivotGridDataCell dataCell = e.Cell as PivotGridDataCell;
if (dataCell != null)
{
switch (dataCell.Text)
{
case ("1"):
dataCell.Text = "R";
break;
case ("2"):
dataCell.Text = "A";
break;
case ("3"):
dataCell.Text = "C";
break;
case ("4"):
dataCell.Text = "I";
break;
case ("5"):
dataCell.Text = "R/A";
break;
case ("10"):
dataCell.Text = "R";
dataCell.BackColor = CFFD_Highlight;
break;
case ("20"):
dataCell.Text = "A";
dataCell.BackColor = CFFD_Highlight;
break;
case ("30"):
dataCell.Text = "C";
dataCell.BackColor = CFFD_Highlight;
break;
case ("40"):
dataCell.Text = "I";
dataCell.BackColor = CFFD_Highlight;
break;
case ("50"):
dataCell.Text = "R/A";
dataCell.BackColor = CFFD_Highlight;
break;
}
dataCell.HorizontalAlign = HorizontalAlign.Center;
}
}
}
Private
Sub
InsertPhotoIntoDB()
Dim
sMyConn
As
String
= My.Settings.appDBConnString
Dim
myConnection
As
SqlConnection
Dim
myCommand
As
New
SqlCommand
myConnection =
New
SqlConnection(sMyConn)
myConnection.Open()
myCommand =
New
SqlCommand(
"INSERT INTO Photos(Photo) VALUES(@Photo)"
)
myCommand.Connection = myConnection
myCommand.Parameters.Add(
"@Photo"
, SqlDbType.Image, 0,
"Photo"
)
myCommand.Parameters(
"@Photo"
).Value = WhatDoIPutHere???
myCommand.ExecuteNonQuery()
myConnection.Close()
myConnection.Dispose()
End
Sub