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";