... <form runat="server"> <telerik:RadScriptManager runat="server" ID="_scriptManager"/> <telerik:RadAjaxManager runat="server" ID="_ajaxManager" RequestQueueSize="100" EnableTheming="true" /> <telerik:RadFormDecorator runat="server" ID="_formDecorator" Skin="Metro" DecoratedControls="All" EnableAjaxSkinRendering="true" /> <telerik:RadSkinManager runat="server" ID="_skinManager" Skin="Metro" /> <div id="wrap"> <div id="header"> <div id="logo"> <img src="" width="200px"/> </div> <table id="Table1" style="width:100%" runat="server"> <tr> <td style="float:left;"> </td> <td style="float:right;"> <telerik:RadButton ID="RadButton1" runat="server" Text="text" OnClick="Unnamed_Click" /> <%--<userControl:AuthenticationUC runat="server"/>--%> </td> </tr> </table> </div> <div id="main"> <asp:ContentPlaceHolder runat="server" ID="MainContent"></asp:ContentPlaceHolder> </div> </div> <div id="footer"> <div> © <%: DateTime.Now.Year %> - Antoine Cloutier </div> </div> </form>...<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="AntoineCloutierWebApp.WebForm1" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <telerik:RadScriptManager runat="server" /> <telerik:RadButton runat="server" Text="text" OnClick="Unnamed_Click" /> </div> </form></body></html>if (rgQuestions.Items.Count > 0){ GridItem gi = rgQuestions.Items[rgQuestions.Items.Count - 1]; ImageButton btnDown = gi.FindControl("btnDown") as ImageButton; btnDown.Visible = false;}Hi,
Iam creating a Class for Pivot grid for programatic creation of grid.
Example :
public static void Layouts(RadPivotGrid grid, int height, int width, Boolean widthtype, Boolean allowsorting)
{
grid.Skin = "Office2007";// set the Skin
grid.EmptyValue = "No data";
grid.Height = height; //Set the height of the grid in % or in pixcel
if (width > 0)
{
if (widthtype == false)
{
grid.Width = width; // set the Width of the grid in % or in pixcel
}
else
{
grid.Width = Unit.Percentage(width);
}
}
grid.AllowSorting = allowsorting;
grid.AllowFiltering = false;
grid.ShowFilterHeaderZone = false;
grid.ShowDataHeaderZone = false;
grid.ShowFilterHeaderZone = false;
grid.ShowRowHeaderZone = false;
grid.ClientSettings.Scrolling.AllowVerticalScroll = true;
grid.ClientSettings.Scrolling.SaveScrollPosition = true;
}
#endregion
//Set all the telerik Grid Page
#region LayoutPage
public static void LayoutPage(RadPivotGrid grid, int pagesize, Boolean allowpaging)
{
grid.PageSize = pagesize;//Set the Grid Page default page size
grid.AllowPaging = allowpaging;//Set Paging for a grid as true or false
// grid.PagerStyle.PageSizeControlType = "RadDropDownList";
}
#endregion
//This function is to set the visblity of Colum and Row total and Subtotal display
#region TotalSettings
public static void TotalSettings(RadPivotGrid grid, TotalsPosition ColumnGrandTotalsPosition, TotalsPosition ColumnsSubTotalsPosition, TotalsPosition RowGrandTotalsPosition, TotalsPosition RowsSubTotalsPosition)
{
grid.TotalsSettings.ColumnGrandTotalsPosition = ColumnGrandTotalsPosition;
grid.TotalsSettings.ColumnsSubTotalsPosition = ColumnsSubTotalsPosition;
grid.TotalsSettings.RowGrandTotalsPosition = RowGrandTotalsPosition;
grid.TotalsSettings.RowsSubTotalsPosition=RowsSubTotalsPosition;
}
#endregion
// bind the Datatable to grid
#region DataBind
public static void DataBinds(RadPivotGrid grid, DataTable dataTable, Boolean needdatasource)
{
grid.DataSource = dataTable;
if (!needdatasource)
{
grid.DataBind();
}
}
public static void DataBinds(RadPivotGrid grid, DataSet dataSet, Boolean needdatasource)
{
DataBinds(grid, dataSet.Tables[0], needdatasource);
}
#endregion
//here we define each column type and value and text
#region PivotgridColumnType
//To set the Grid header column groups
#region PivotGridRowFiled
public static void PivotGridRowFiled(RadPivotGrid grid, String datafield, String UniqueName, int Width,TelerikControlType Columntype,String contolID)
{
PivotGridRowField rowField = new PivotGridRowField();
if(Columntype!=TelerikControlType.None)
{
rowField.CellTemplate = new MyTemplate(datafield, Columntype.ToString(), Width - 2, contolID);
}
rowField.DataField = datafield;
rowField.UniqueName = UniqueName;
rowField.CellStyle.Width = Width;
grid.Fields.Add(rowField);
}
#endregion
#region PivotGridColumnFiled
public static void PivotGridColumnFiled(RadPivotGrid grid, String datafield, String UniqueName, int Width)
{
PivotGridColumnField columnField = new PivotGridColumnField ();
// rowField.CellTemplate=
columnField.DataField = datafield;
columnField.UniqueName = UniqueName;
columnField.CellStyle.Width = Width;
grid.Fields.Add(columnField);
}
#endregion
#region PivotGridAggregateFiled
public static void PivotGridAggregateFiled(RadPivotGrid grid, String datafield, String UniqueName, int Width,String DataFormatString,String totalformatString)
{
PivotGridColumnField aggregateField = new PivotGridColumnField ();
// rowField.CellTemplate=
aggregateField.DataField = datafield;
aggregateField.UniqueName = UniqueName;
aggregateField.CellStyle.Width = Width;
aggregateField.DataFormatString = DataFormatString;
aggregateField.TotalFormatString = totalformatString;
grid.Fields.Add(aggregateField);
}
#endregion
#endregion
function OnClientDropping(sender, args) { var orgChart = $find("<%= RadOrgChart1.ClientID %>"); var itemText = args.get_sourceItem().get_text().trim(); if (args.get_htmlElement().className.indexOf("rocItem") != -1 || $(args.get_htmlElement()).parents(".rocItem").length > 0) { var hierarchicalIndex = orgChart._extractNodeFromDomElement(args.get_htmlElement())._getHierarchicalIndex(); hierarchicalIndex = orgChart._getRealHierarchicalIndex(hierarchicalIndex); //gets right index if drill down is on $find("<%= RadAjaxManager2.ClientID %>").ajaxRequest("drop-" + itemText + "-" + hierarchicalIndex); } dropClue.style.display = "none"; noDropClue.style.display = "none";}char[] seps = { '-' }; string[] textAndIds = e.Argument.Split(seps, StringSplitOptions.None); char[] sep = { ':' }; string[] stringIds = textAndIds[2].Split(sep, StringSplitOptions.RemoveEmptyEntries); int[] ids = new int[stringIds.Length]; for (int i = 0; i < stringIds.Length; i++) { ids[i] = Int32.Parse(stringIds[i]); } if (textAndIds[0] == "drop") { string newText = textAndIds[1]; OrgChartNode node = RadOrgChart1.GetNodeByHierarchicalIndex(ids); var rows = from myRow in initialeEmployees.AsEnumerable() where myRow.Field<string>("FullName") == newText select new { values = myRow }; string imageUrl = ""; string emloyeeId = ""; foreach (var row in rows) { imageUrl = row.values.Field<string>("ImageUrl"); emloyeeId = row.values.Field<string>("EmployeeID"); break; } employees.Rows.Add(new string[] { emloyeeId, node.ID, newText, imageUrl }); }