private void ActiveBatchesRadGrid_ItemCommand(object source, GridCommandEventArgs e)
{
if (e.CommandName == RadGrid.InitInsertCommandName)
{
GridTableView _gridTableView = (GridTableView)e.Item.OwnerTableView;
}
if (e.CommandName == RadGrid.ExportToExcelCommandName)
{
GridTableView _gridTableView = (GridTableView) e.Item.OwnerTableView;
_gridTableView.GetColumn("PolicyEditRecord").Visible = false;
_gridTableView.GetColumn("PolicyDeleteRecord").Visible = false;
this.__activeBatchesRadGrid.MasterTableView.HierarchyDefaultExpanded = true;
}
if (e.CommandName == RadGrid.ExpandCollapseCommandName)
{
e.Item.Selected = !e.Item.Expanded;
}
}
private RadGrid DefineGridStructure()
{
RadGrid grid = new RadGrid();
grid.ID = "OptOutGrid";
grid.Width = Unit.Percentage(100);
//grid.Height = Unit.Pixel(400);
grid.CssClass = "LeftFloat Top15Margin RadGridAutoSize";
grid.PageSize = 25;
grid.EnableAjaxSkinRendering = true;
grid.AllowPaging = true;
grid.AutoGenerateColumns = false;
grid.AllowMultiRowSelection = true;
grid.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric;
grid.ClientSettings.Selecting.AllowRowSelect = true;
grid.ClientSettings.Selecting.UseClientSelectColumnOnly = true;
grid.ClientSettings.Scrolling.AllowScroll = true;
grid.ClientSettings.Scrolling.UseStaticHeaders = true;
grid.ClientSettings.Scrolling.SaveScrollPosition = true;
//grid.MasterTableView.DataKeyNames = new string[] { "PanelistID" };
grid.MasterTableView.TableLayout = GridTableLayout.Fixed;
GridBoundColumn col;
col = new GridBoundColumn();
col.DataField = "PanelistID";
col.HeaderText = (string)GetLocalResourceObject("grid_PanelistID");
col.UniqueName = "PanelistID";
grid.MasterTableView.Columns.Add(col);
col = new GridBoundColumn();
col.DataField = "FirstName";
col.HeaderText = (string)GetLocalResourceObject("grid_PanelistFirstName");
col.UniqueName = "FirstName";
grid.MasterTableView.Columns.Add(col);
col = new GridBoundColumn();
col.DataField = "LastName";
col.HeaderText = (string)GetLocalResourceObject("grid_PanelistLastName");
col.UniqueName = "LastName";
grid.MasterTableView.Columns.Add(col);
col = new GridBoundColumn();
col.DataField = "Email";
col.HeaderText = (string)GetLocalResourceObject("grid_PanelistEmail");
col.UniqueName = "Email";
grid.MasterTableView.Columns.Add(col);
GridCheckBoxColumn chk;
chk = new GridCheckBoxColumn();
chk.DataField = "IsOptIn";
chk.HeaderText = (string)GetLocalResourceObject("grid_PanelistOptIn");
chk.ReadOnly = true;
grid.MasterTableView.Columns.Add(chk);
GridClientSelectColumn select = new GridClientSelectColumn();
grid.MasterTableView.Columns.Add(select);
return grid;
}
protected void PopulatePanelistGrid(List<int> ids)
{
RadGrid grid = DefineGridStructure();
grid.DataSource = GetPanelistData(ids);
grid.DataBind();
pnl_gridPanel.Controls.Add(grid);
}
<
telerik:RadGrid
ID
=
"RadGrid4"
runat
=
"server"
DataSourceID
=
"SqlDataSource4"
GridLines
=
"None"
AllowSorting
=
"True"
AllowPaging
=
"True"
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
MasterTableView
AutoGenerateColumns
=
"False"
DataSourceID
=
"SqlDataSource4"
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
/>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
/>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"MetricName"
HeaderText
=
""
ReadOnly
=
"True"
UniqueName
=
"MetricName"
HeaderTooltip
=
"Metric Name"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MetricValue"
DataType
=
"System.Decimal"
HeaderText
=
"Sales"
ReadOnly
=
"True"
DataFormatString
=
"{0:$###,###.##}"
UniqueName
=
"MetricValue"
HeaderTooltip
=
"Metric Value"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MetricComp"
DataType
=
"System.Decimal"
DataFormatString
=
"{0:#.#%;(#.#%);''}"
HeaderText
=
"Comp %"
ReadOnly
=
"True"
HeaderTooltip
=
"MetricComp"
UniqueName
=
"MetricComp"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
protected
void
RadGrid4_ItemDataBound(
object
sender, Telerik.Web.UI.GridItemEventArgs e)
{
if
(e.Item
is
GridDataItem)
{
GridDataItem dataItem = e.Item
as
GridDataItem;
if
(dataItem[
"MetricName"
].Text ==
"Average Trans"
)
dataItem.CssClass =
"AverageTransRowClass"
;
}
}
<div>
<telerik:RadChart ID=
"RadChart1"
runat=
"server"
DataSourceID=
"SqlDataSource1"
Height=
"400px"
Skin=
"Vista"
Width=
"800px"
>
</telerik:RadChart>
<asp:SqlDataSource ID=
"SqlDataSource1"
runat=
"server"
ConnectionString=
"<%$ ConnectionStrings:EUD_SD_TodoListConnectionString %>"
SelectCommand=
"select s.Description [Status], DateName( month , DateAdd( month , Month(i.StartC) , 0 ) - 1 ) as [Month], count(*) as [Value] from Items i INNER JOIN Status s ON s.ID = i.StatusID where Year(i.StartC) = 2011 group by s.Description, Month(i.StartC) order by Month(i.StartC) desc"
>
</asp:SqlDataSource>
</div>
RadChart1.DataGroupColumn =
"Status"
;
RadChart1.PlotArea.XAxis.DataLabelsColumn =
"Month"
;
RadChart1.Legend.Appearance.GroupNameFormat =
"#NAME:#VALUE"
;