Questions on UI for ASP.NET AJAX Forum

7 answers

224 views

Hi,
I use radgrid with these settings

Me.ResultsGrid.MasterTableView.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric
Me.ResultsGrid.MasterTableView.PagerStyle.Position = GridPagerPosition.Top
Me.ResultsGrid.MasterTableView.PagerStyle.PageButtonCount = 10

I want to hide the border for the pager, as the pager is placed on top, the top-line caused by the styles are not in sync with my design,
so i want to hide the border.

.RadGrid_Default .rgPager .rgPagerCell

border-color:#828282 -moz-use-text-color #EEEEEE #EEEEEE;

border-style:solid none solid solid;

border-width:1px 0 1px 1px;

I tried setting
Me.ResultsGrid.MasterTableView.PagerStyle.BorderStyle = WebControls.BorderStyle.None
but no use.

How i can set it from code-behind?

Grid

answered on 10 Mar 2015

1 answer

113 views

RadGrid bug on filtering with EntityDataSource

wherever I try to filter a bounded column with RadGrid I get the following error:

"Could not resolve 'COLUMN NAME' in scope or current context. Check
that all referenced variables are in scope, if required schemes were
loaded and references to namespaces are correct. Next simple identifier,
line 6, column 3."

My page's code is:

<%@ Page Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="VerOcorrencias.aspx.cs" Inherits="DuctorWebSite.OuvidoriaPages.VerOcorrencias" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">

<meta http-equiv='cache-control' content='no-cache'>

<meta http-equiv='expires' content='0'>

<meta http-equiv='pragma' content='no-cache'>

<link href="../Content/OuvidoriaPages.css" rel="stylesheet" />

<div class="container-full">

<h2>Lista de ocorrências</h2>

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="EntityDataSource1"

RenderMode="Auto" Culture="pt-BR" Skin="Metro"

AllowAutomaticDeletes="True" AllowFilteringByColumn="True" AllowPaging="True"

AutoGenerateColumns="False" OnItemCommand="RadGrid1_ItemCommand" EnableLinqExpressions="False" GroupPanelPosition="Top">

<ExportSettings>

<Pdf PageWidth="">

</Pdf>

</ExportSettings>

<MasterTableView DataSourceID="EntityDataSource1" DataKeyNames="OUV_Id" PageSize="25">

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn" CancelText="Cancelar" EditText="Editar" UpdateText="Confirmar" ButtonType="ImageButton" CancelImageUrl="../Images/icons/cancelar.png"

UpdateImageUrl="../Images/icons/ok.png">

</EditColumn>

</EditFormSettings>

<Columns>

<telerik:GridButtonColumn CommandName="Editar" Text="Editar resposta" UniqueName="EditCommandColumn" ButtonType="ImageButton" ImageUrl="../Images/icons/editar.png" Resizable="False">

<ItemStyle Width="41px" />

</telerik:GridButtonColumn>

<telerik:GridButtonColumn CommandName="Delete" Text="Apagar mensagem inteira" UniqueName="DeleteColumn" ConfirmText="Você tem certeza que quer apagar essa mensagem?" ConfirmDialogType="RadWindow" ConfirmDialogHeight="25px" HeaderStyle-Width="15px" ItemStyle-Width="15px"

ButtonType="ImageButton" ImageUrl="../Images/icons/apagar.png">

<HeaderStyle Width="15px" />

<ItemStyle Width="41px" />

</telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="OUV_Id" DataType="System.Int32" Display="False" FilterControlAltText="Filter OUV_Id column" HeaderText="OUV_Id" ReadOnly="True" SortExpression="OUV_Id" UniqueName="OUV_Id" Visible="False" Resizable="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<ItemStyle Width="41px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_DtdRegistro" DataType="System.DateTime" FilterControlAltText="Filter OUV_DtdRegistro column" HeaderText="<b>DATA REGISTRO</b

>" SortExpression="OUV_DtdRegistro" UniqueName="OUV_DtdRegistro" ReadOnly="True" DataFormatString="{0:dd/MM/yyyy}" Resizable="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<ItemStyle Width="50px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_Protocolo" DataType="System.Double" FilterControlAltText="Filter OUV_Protocolo column" HeaderText="<b>PROTOCOLO</b>" SortExpression="OUV_Protocolo" UniqueName="OUV_Protocolo" ReadOnly="True" Resizable="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<ItemStyle Width="30px" />

</telerik:GridBoundColumn>

<telerik:GridCalculatedColumn DataFields="OUV_Nome,OUV_Email,OUV_Telefone" FilterControlAltText="Filter column column" UniqueName="column" Expression="OUV_Nome + '<br/>' + OUV_Email + '<br/>' + OUV_Telefone" HeaderText="<b>IDENTIFICAÇÃO</b>" Resizable="False">

<FooterStyle Width="100px" />

<ItemStyle Width="80px" />

</telerik:GridCalculatedColumn>

<telerik:GridBoundColumn DataField="OUV_Mensagem" FilterControlAltText="Filter OUV_Mensagem column" HeaderText="<b>MENSAGEM</b>" SortExpression="OUV_Mensagem" UniqueName="OUV_Mensagem" ReadOnly="True" Resizable="False" MaxLength="150">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<FooterStyle Width="500px" />

<ItemStyle Width="250px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_DtdResposta" DataType="System.DateTime" FilterControlAltText="Filter OUV_DtdResposta column" HeaderText="<b>DATA RESPOSTA</b

>" SortExpression="OUV_DtdResposta" UniqueName="OUV_DtdResposta" ReadOnly="True" DataFormatString="{0:dd/MM/yyyy}" Resizable="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<ItemStyle Width="30px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_Resposta" FilterControlAltText="Filter OUV_Resposta column" HeaderText="<b>RESPOSTA</b>" SortExpression="OUV_Resposta" UniqueName="OUV_Resposta" Resizable="False" MaxLength="150">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<ItemStyle Width="250px" Wrap="True" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_Nome" FilterControlAltText="Filter OUV_Nome column" HeaderText="OUV_Nome" SortExpression="OUV_Nome" UniqueName="OUV_Nome" Display="False" ReadOnly="True" Visible="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_Email" FilterControlAltText="Filter OUV_Email column" HeaderText="OUV_Email" SortExpression="OUV_Email" UniqueName="OUV_Email" Display="False" ReadOnly="True" Visible="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_Telefone" FilterControlAltText="Filter OUV_Telefone column" HeaderText="OUV_Telefone" SortExpression="OUV_Telefone" UniqueName="OUV_Telefone" Display="False" ReadOnly="True" Visible="False">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OUV_ChaveLoc" Display="False" FilterControlAltText="Filter OUV_ChaveLoc column" HeaderText="OUV_ChaveLoc" SortExpression="OUV_ChaveLoc" UniqueName="OUV_ChaveLoc" Visible="False" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="OUV_Ativo" DataType="System.Boolean" Display="False" FilterControlAltText="Filter OUV_Ativo column" HeaderText="OUV_Ativo" SortExpression="OUV_Ativo" UniqueName="OUV_Ativo" Visible="False" ReadOnly="True">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="OUV_idCAT" Display="False" FilterControlAltText="Filter OUV_idCAT column" HeaderText="OUV_idCAT" SortExpression="OUV_idCAT" UniqueName="OUV_idCAT" Visible="False" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CAT_Descr" Display="False" FilterControlAltText="Filter CAT_Descr column" HeaderText="CAT_Descr" SortExpression="CAT_Descr" UniqueName="CAT_Descr" Visible="False" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

</Columns>

<PagerStyle Position="TopAndBottom" />

</MasterTableView>

<FilterMenu RenderMode="Mobile">

</FilterMenu>

<HeaderContextMenu RenderMode="Mobile">

</HeaderContextMenu>

</telerik:RadGrid>

</div>

<asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=DuctorWebSiteEntities"

DefaultContainerName="DuctorWebSiteEntities" EnableDelete="True" EnableFlattening="False" EntitySetName="Ouvidoria" OrderBy="it.OUV_DtdRegistro Desc" EntityTypeFilter="Ouvidoria">

</asp:EntityDataSource>

</asp:Content>

I need some help, thanks.

Grid

answered on 10 Mar 2015

6 answers

279 views

RadEditor default font style not applied upon typing

Hello,

If you begin typing in the editor without selecting anything from the toolbar, no "default" formatting is applied. If you switch between Design and HTML mode you see just the text you typed. No HTML is applied.

I've tried setting default toolbar font options using the OnClientLoad event but these selections are not applied upon typing.

Any suggestions would be appreciated.

Thanks

Blair

Editor

answered on 10 Mar 2015

12 answers

246 views

Radribbonbutton Navigation Url

I notice that radribbonbutton does not have a NavigationUrl Property to navigate to a specific aspx. Is there a property to navigate to aspx from the radribbonbutton. If not, How would I do it in code from the .cs file.

protected void RadRibbonBar1_ButtonClick(object sender, Telerik.Web.UI.RibbonBarButtonClickEventArgs e)
    {
        switch (e.Button.Text)
        {
            case "Calender":
                break;

            default:
                break;
        }

RibbonBar

answered on 10 Mar 2015

5 answers

118 views

Custom Column Render Problem

I created my own Template column. Everything works ok. But when I add a child hierarchy and expand any row, the values of that column in the father grid are lost.

Any suggestions on this?

I added part of my code to show the situation.

Code:

public class MyGridTemplateColumn : GridTemplateColumn
{
    public override void Initialize()
    {
        base.Initialize();

        HeaderStyle.Width = Unit.Pixel(105);
        HeaderText = "State";
        UniqueName = "StateCol";

        DataField = "StateId";
        DataType = typeof(byte);

        var _dataSource = new List<KeyValuePair<int, string>>
        {
            new KeyValuePair<int, string>(1, "Active"),
            new KeyValuePair<int, string>(2, "Deleted"),
            new KeyValuePair<int, string>(3, "Inactive"),
            new KeyValuePair<int, string>(6, "Other")
        };

        ItemTemplate = new MyItemTemplate(this.DataField, _dataSource);
        EditItemTemplate = new MyEditItemTemplate(this.DataField, _dataSource);
    }

    public override GridColumn Clone()
    {
        var res = new MyGridTemplateColumn();
        res.CopyBaseProperties(this);

        return res;
    }

    private class MyItemTemplate : ITemplate
    {
        private readonly string _dataField;
        private readonly List<KeyValuePair<int, string>> _dataSource = new List<KeyValuePair<int, string>>();

        public MyItemTemplate(string dataField, List<KeyValuePair<int, string>> origenDatos)
        {
            _dataField = dataField;
            _dataSource = origenDatos;
        }

        public void InstantiateIn(System.Web.UI.Control container)
        {
            var lControl = new LiteralControl { ID = _dataField + "_lControl" };
            lControl.DataBinding += lControl_DataBinding;
            container.Controls.Add(lControl);
        }

        private void lControl_DataBinding(object sender, EventArgs e)
        {
            var l = (LiteralControl)sender;
            var value = l.NamingContainer.GetFieldValue("DataItem." + _dataField);
            if (value != null)
                l.Text = _dataSource.FirstOrDefault(s=>s.Key == (int)value).Value;
        }
    }

    private class MyEditItemTemplate : IBindableTemplate
    {
        private readonly string _dataField;
        private readonly List<KeyValuePair<int, string>> _dataSource = new List<KeyValuePair<int, string>>();

        public MyEditItemTemplate(string dataField, List<KeyValuePair<int, string>> origenDatos)
        {
            _dataField = dataField;
            _dataSource = origenDatos;
        }

        public void InstantiateIn(System.Web.UI.Control container)
        {
            var rcBox = new RadComboBox
            {
                ID = _dataField + "_RadComboBox",
                DataTextField = "Value",
                DataValueField = "Key",
                DataSource = _dataSource
            };

            rcBox.DataBinding += rcBox_DataBinding;
            container.Controls.Add(rcBox);
        }

        public IOrderedDictionary ExtractValues(Control container)
        {
            var dictionary = new OrderedDictionary
            {
                {_dataField, (container.FindControl(_dataField + "_RadComboBox") as RadComboBox).SelectedValue}
            };
            return dictionary;
        }

        private void rcBox_DataBinding(object sender, EventArgs e)
        {
            var rcBox = (RadComboBox)sender;
            var value = rcBox.NamingContainer.GetFieldValue("DataItem." + _dataField);
            rcBox.SelectedValue = value != null ? value.ToString() : string.Empty;
        }
    }

Usage:

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="LinqDataSource1" AllowPaging="True" AutoGenerateColumns="False" Width="50%">
    <MasterTableView DataKeyNames="ENTUserAccountId" DataSourceID="LinqDataSource1" PageSize="5">
        <Columns>
            <telerik:GridBoundColumn DataField="UserName" HeaderText="UserName" UniqueName="UserName"/>
            <telerik:GridBoundColumn DataField="Email" HeaderText="Email" UniqueName="Email"/>
            <a:MyGridTemplateColumn />
        </Columns>
        <DetailTables>
            <telerik:GridTableView runat="server" DataSourceID="LinqDataSource2" DataKeyNames="ENTUserAccountId">
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="ENTUserAccountId" MasterKeyField="ENTUserAccountId" />
                </ParentTableRelation>
                <Columns>
                    <telerik:GridTemplateColumn DataField="ENTRoleId" HeaderText="Rol" UniqueName="ENTRoleId">
                        <ItemTemplate>
                            <asp:Label ID="ENTRoleIdLabel" runat="server" Text='<%# Eval("ENTRole.RoleName") %>'></asp:Label>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
            </telerik:GridTableView>
        </DetailTables>
    </MasterTableView>
</telerik:RadGrid>

<asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="TelerikWebApp1.DataClasses1DataContext"
    EntityTypeName="" TableName="ENTUserAccount"/>

<asp:LinqDataSource ID="LinqDataSource2" runat="server" ContextTypeName="TelerikWebApp1.DataClasses1DataContext"
    EntityTypeName="" TableName="ENTRoleUserAccount" Where="ENTUserAccountId == @ENTUserAccountId">
        <WhereParameters>
            <asp:SessionParameter Name="ENTUserAccountId" Type="Int32" />
        </WhereParameters>
</asp:LinqDataSource>

Grid

answered on 10 Mar 2015

4 answers

141 views

Object doesn't support property or method 'add_show'

Hi

I'm using add_show from Radwindow but sinds installing version UI for ASP.NET AJAX Q1 2015, I get following error :

Object doesn't support property or method 'add_show'

This is the javascript function I use it in it:

function openChildDialog(url, wndName, title) {

if (!url)

url = "errorPage.aspx";

if (!wndName)

wndName = "popup_" + Math.random();

var currentWnd = GetRadWindow();

var browserWnd = window;

if (currentWnd)

browserWnd = currentWnd.BrowserWindow;

setTimeout(function () {

browserWnd.add_show(returnDataToParentPopup);

var wnd = browserWnd.radopen(url, wndName);

wnd.__parentBackReference = window; //pass the current window object of the page that opens the dialog so it can be used later

if (title)

wnd.set_title(title);

}, 0);

Can someone please help me? It is urgent because no window is opening in my production environment!

Kind regards

Suzy

Window

answered on 10 Mar 2015

1 answer

173 views

OnRowDrop not firing

Hi, I've got a grid where neither the client nor server side events are firing on row drop, the target grid:
     <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1"
                             EnableViewState="False" GridLines="None" Width="475px" AutoGenerateDeleteColumn="True"
                             AllowAutomaticDeletes="True"
                            AllowMultiRowSelection="true"
                             OnDeleteCommand="RadGrid1_DeleteCommand"
                            OnRowDrop="RadGrid1_RowDrop"
                            OnItemCreated="RadGrid1_ItemCreated">
                 <ClientSettings EnableRowHoverStyle="True" AllowRowsDragDrop="True">
                <Selecting AllowRowSelect="True" EnableDragToSelectRows="false" />
                            <ClientEvents  OnRowDropping="onRowDropping"></ClientEvents>
                </ClientSettings>

Grid

answered on 10 Mar 2015

4 answers

93 views

Use RadWindow radconfirm with RadIconTile

I need to use a radwindow confirmation with an icontile just like you would with a button. How would I accomplish this with javascript?

TileList

answered on 10 Mar 2015

2 answers

125 views

RAD Editor - CSS class name is shown instead of user-friendly name in the dropdown

Hi Team,

I am using custom css file and showing few css classes with user friendly names in "Apply CSS Class" drop down box of RAD Editor Tool bar.
I used following code in ToolsFile.xml to show user-friendly names corresponding to custom css classes:

<classes>

<class name="Clear Class" value="" />

<class name="ContentLink" value="a.oc-rteElement-ContentLink" />

<class name="ContentBody" value=".oc-rteStyle-ContentBody" />

<class name="Arrow/Separator" value=".oc-rteStyle-ContentArrowSeparator" />

<class name="ContentHeading" value=".oc-rteStyle-ContentHeading" />

<class name="CorporateHeading" value=".oc-rteStyle-ContentHeadingCorporate" />

<class name="PrivateEquityHeading" value=".oc-rteStyle-ContentHeadingPrivateEquity" />

<class name="CovertiblesHeading" value=".oc-rteStyle-ContentHeadingCovertibles" />

<class name="ListedEquityHeading" value=".oc-rteStyle-ContentHeadingListedEquity"

/>

....

....

</classes>

Initially in the RAD Editor Toolbar, user-friendly names are shown in “Apply CSS Class” drop down box as shown in below figure:

After we select a style and apply it to some content, then the internal css class name of the style gets displayed on the drop down as shown below:

Kindly suggest how can I resolve this issue that internal css class name not shown to user.

Thanks & Regards,
Lipi

Editor

answered on 10 Mar 2015

4 answers

168 views

Parameter count mismatch error in VS2010 after conversion the project from VS2005

Hi,

We are using the following controls in our VS2005 project.

radiobuttonlist
RadWindowManager
RadGrid

We have converted that project from VS2005 to VS2010.
When we are running the project in 4.0 of the VS2010, we got the following error like "Parameter count mismatch."

After that I set enableViewState = "false" in web.config, it was loading well.

The expand of the Grid is fine but when we click on this symbol (-) to collapse, it produces the same error like

"Parameter count mismatch."

I have attached the screen shot.

Kindly do the needful.

aspx
******

<%@ Register Assembly="RadWindow.Net2" Namespace="Telerik.WebControls" TagPrefix="radW" %>
<%@ Register Assembly="RadCombobox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %>
<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
<%@ Register TagPrefix="UserControl" TagName="Header" Src="header.ascx" %>
<%@ Register TagPrefix="UserControl" TagName="Footer" Src="footer.ascx" %>

<link href="hierarchy.css" rel="stylesheet" type="text/css" />
<UserControl:Header ID="myHeader" runat="Server"></UserControl:Header>
<table border="0" width="100%" cellpadding="5" cellspacing="0" height="390" style="border-right: silver 1px solid;
    border-top: silver 1px solid; border-left: silver 1px solid; border-bottom: silver 1px solid">
    <form id="Form1" method="post" runat="server">
        <tr>
            <td colspan="3" height="22" style="border-bottom: silver 1px solid;" align="left"
                valign="top">
                  <font class="Bread"> Cycle :: Task Status</font>
            </td>
        </tr>
        <tr valign="middle" align="left">
            <td width="5%">
                <table cellpadding="0" cellspacing="0">
                    <tr>
                        <td>
                            <div id="btnRefreshB" runat="server">
                                <input type="button" class="Button" value="Refresh" onclick='RadGridNamespace.AsyncRequest( "<%= RadGrid1.ClientID %>", "Rebind", "<%= RadGrid1.ClientID %>")' />
                            </div>


                        </td>
                    </tr>
                </table>
            </td>
            <td>
                <table cellpadding="0" cellspacing="0" width="350" class="RadGrid" style="border: #cccccc 1px solid;">
                    <tr>
                        <td class="HeaderNew" align="center">
                            <label>
                                Select Site</label>
                        </td>
                    </tr>

                    <tr>
                        <td class="Row">

                            <asp:radiobuttonlist id="rbSites" runat="server" width="350" onselectedindexchanged="rbSites_SelectedIndexChanged"
                                autopostback="True" repeatdirection="Horizontal"><asp:ListItem Selected="True" Value="('B')">Billing</asp:ListItem>
</asp:radiobuttonlist>
                        </td>
                    </tr>
                </table>
            </td>

        </tr>
        <tr>
            <td width="820" colspan="3">
                <table cellpadding="0" cellspacing="0" border="0">
                    <tr>
                        <td>
                            <radW:RadWindowManager ID="RadWindowManager1" runat="server">
                                <Windows>
                                    <radW:RadWindow ID="RadWindow1" runat="server" Left="" Title="XMS Admin" Top="" Height="550px"
                                        NavigateUrl="" VisibleStatusbar="False" Width="840px" EnableTheming="False" MinimizeMode="MinimizeZone"
                                        MinimizeZoneId="MinimizeZone" />
                                </Windows>
                            </radW:RadWindowManager>

                           <radG:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" PageSize="100" CssClass="RadGrid"
                                HorizontalAlign="NotSet" EnableAsyncRequests="True" Width="930px" AllowSorting="True"
                                DataSourceID="XMS_CYCLE_TASK_B">
                                <MasterTableView AutoGenerateColumns="False" DataKeyNames="TASK_ID" DataSourceID="XMS_CYCLE_TASK_B">
                                    <EditFormSettings>
                                        <EditColumn UniqueName="EditCommandColumn">
                                        </EditColumn>
                                    </EditFormSettings>
                                    <Columns>
                                        <radG:GridBoundColumn DataField="TASK_ID" DataType="System.Decimal" HeaderText="Task ID"
                                            ReadOnly="True" SortExpression="TASK_ID" UniqueName="TASK_ID">
                                            <ItemStyle HorizontalAlign="Center" />
                                        </radG:GridBoundColumn>
                                        <radG:GridHyperLinkColumn DataTextField="CYCLE_ID" DataType="System.Decimal" HeaderText="Cycle ID"
                                            DataNavigateUrlField="CYCLE_ID" DataNavigateUrlFormatString="javascript:function anon(){{window.radopen('dal_policy_detail.aspx?CycleId={0}','RadWindow1');}};anon();"
                                            SortExpression="CYCLE_ID" UniqueName="CYCLE_ID">
                                            <ItemStyle HorizontalAlign="Center" />
                                        </radG:GridHyperLinkColumn>
                                        <radG:GridHyperLinkColumn DataTextField="STATUS_NAME" HeaderText="Status" DataNavigateUrlField="TASK_ID"
                                            DataNavigateUrlFormatString="javascript:function anon(){{window.radopen('log_viewer.aspx?AuditId={0}&EventSourceID=3','RadWindow1');}};anon();"
                                            SortExpression="STATUS_NAME" UniqueName="STATUS_NAME_1">
                                            <ItemStyle HorizontalAlign="Center" />
                                        </radG:GridHyperLinkColumn>
                                        <radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" ReadOnly="True"
                                            SortExpression="STATUS_NAME" UniqueName="STATUS_NAME_2">
                                            <ItemStyle HorizontalAlign="Center" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="SYSTEM_NAME" HeaderText="System" SortExpression="SYSTEM_NAME"
                                            UniqueName="SYSTEM_NAME">
                                            <ItemStyle HorizontalAlign="Center" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="DOCUMENT_COUNT" HeaderText="T" SortExpression="DOCUMENT_COUNT"
                                            UniqueName="DOCUMENT_COUNT">
                                            <ItemStyle HorizontalAlign="Center" Width="16px" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="ERROR_COUNT" HeaderText="F" SortExpression="ERROR_COUNT"
                                            UniqueName="ERROR_COUNT">
                                            <ItemStyle HorizontalAlign="Center" Width="16px" ForeColor="Red" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
                                            SortExpression="START_TIME" UniqueName="START_TIME">
                                            <ItemStyle HorizontalAlign="Left" Width="130px" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
                                            SortExpression="END_TIME" UniqueName="END_TIME">
                                            <ItemStyle HorizontalAlign="Left" Width="130px" />
                                        </radG:GridBoundColumn>
                                    </Columns>
                                    <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
                                        <HeaderStyle Width="19px" />
                                    </ExpandCollapseColumn>
                                    <DetailTables>
                                        <radG:GridTableView DataKeyNames="DEST_ID" DataSourceID="XMS_CYCLE_DEST_D" AutoGenerateColumns="False"
                                            runat="server" HierarchyDefaultExpanded="True">
                                            <ParentTableRelation>
                                                <radG:GridRelationFields DetailKeyField="TASK_ID" MasterKeyField="TASK_ID" />
                                            </ParentTableRelation>
                                            <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
                                                <HeaderStyle Width="19px" />
                                            </ExpandCollapseColumn>
                                            <RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
                                                <HeaderStyle Width="20px" />
                                            </RowIndicatorColumn>
                                            <Columns>
                                                <radG:GridBoundColumn DataField="DEST_ID" DataType="System.Decimal" HeaderText="Dest ID"
                                                    SortExpression="DEST_ID" UniqueName="DEST_ID">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                </radG:GridBoundColumn>
                                                <radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
                                                    UniqueName="STATUS_NAME">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                </radG:GridBoundColumn>
                                                <radG:GridBoundColumn DataField="PRINT_DEST" HeaderText="Jobs" SortExpression="PRINT_DEST"
                                                    UniqueName="PRINT_DEST">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                </radG:GridBoundColumn>

                                                <radG:GridBoundColumn DataField="POLICY_COUNT" HeaderText="Policies" SortExpression="POLICY_COUNT"
                                                    UniqueName="POLICY_COUNT">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                </radG:GridBoundColumn>
                                                <radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
                                                    SortExpression="START_TIME" UniqueName="START_TIME">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                </radG:GridBoundColumn>
                                                <radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
                                                    SortExpression="END_TIME" UniqueName="END_TIME">
                                                    <ItemStyle HorizontalAlign="Center" />
                                                </radG:GridBoundColumn>
                                            </Columns>
                                            <DetailTables>
                                                <radG:GridTableView runat="server" DataKeyNames="SUBTASK_ID" DataSourceID="XMS_CYCLE_SUBTASK_D"
                                                    AutoGenerateColumns="False" HierarchyDefaultExpanded="True">
                                                    <ParentTableRelation>
                                                        <radG:GridRelationFields DetailKeyField="DEST_ID" MasterKeyField="DEST_ID" />
                                                    </ParentTableRelation>
                                                    <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
                                                        <HeaderStyle Width="19px" />
                                                    </ExpandCollapseColumn>
                                                    <RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
                                                        <HeaderStyle Width="20px" />
                                                    </RowIndicatorColumn>
                                                    <Columns>
                                                        <radG:GridBoundColumn DataField="SUBTASK_ID" DataType="System.Decimal" HeaderText="SubTask ID"
                                                            SortExpression="SUBTASK_ID" UniqueName="SUBTASK_ID">
                                                            <ItemStyle HorizontalAlign="Center" />
                                                        </radG:GridBoundColumn>
                                                        <radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
                                                            UniqueName="STATUS_NAME">
                                                            <ItemStyle HorizontalAlign="Center" />
                                                        </radG:GridBoundColumn>
                                                        <radG:GridBoundColumn DataField="SUBSYSTEM_NAME" DataType="System.Decimal" HeaderText="Sub System"
                                                            SortExpression="SUBSYSTEM_NAME" UniqueName="SUBSYSTEM_NAME">
                                                            <ItemStyle HorizontalAlign="Center" />
                                                        </radG:GridBoundColumn>
                                                        <radG:GridBoundColumn DataField="POLICY_COUNT" DataType="System.Decimal" HeaderText="Policies"
                                                            SortExpression="POLICY_COUNT" UniqueName="POLICY_COUNT">
                                                            <ItemStyle HorizontalAlign="Center" />
                                                        </radG:GridBoundColumn>
                                                        <radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
                                                            SortExpression="START_TIME" UniqueName="START_TIME">
                                                            <ItemStyle HorizontalAlign="Center" />
                                                        </radG:GridBoundColumn>
                                                        <radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
                                                            SortExpression="END_TIME" UniqueName="END_TIME">
                                                            <ItemStyle HorizontalAlign="Center" />
                                                        </radG:GridBoundColumn>
                                                    </Columns>
                                                    <DetailTables>
                                                        <radG:GridTableView runat="server" DataKeyNames="BATCH_ID" DataSourceID="XMS_CYCLE_BATCH_D"
                                                            AutoGenerateColumns="False">
                                                            <ParentTableRelation>
                                                                <radG:GridRelationFields DetailKeyField="SUBTASK_ID" MasterKeyField="SUBTASK_ID" />
                                                            </ParentTableRelation>
                                                            <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False">
                                                                <HeaderStyle Width="19px" />
                                                            </ExpandCollapseColumn>
                                                            <RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
                                                                <HeaderStyle Width="20px" />
                                                            </RowIndicatorColumn>
                                                            <Columns>
                                                                <radG:GridBoundColumn DataField="BATCH_ID" DataType="System.Decimal" HeaderText="Batch ID"
                                                                    SortExpression="BATCH_ID" UniqueName="BATCH_ID">
                                                                    <ItemStyle HorizontalAlign="Center" />
                                                                </radG:GridBoundColumn>
                                                                <radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
                                                                    UniqueName="STATUS_NAME">
                                                                    <ItemStyle HorizontalAlign="Center" />
                                                                </radG:GridBoundColumn>
                                                                <radG:GridBoundColumn DataField="POLICY_COUNT" DataType="System.Decimal" HeaderText="Policies"
                                                                    SortExpression="POLICY_COUNT" UniqueName="POLICY_COUNT">
                                                                    <ItemStyle HorizontalAlign="Center" />
                                                                </radG:GridBoundColumn>
                                                                <radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
                                                                    SortExpression="START_TIME" UniqueName="START_TIME">
                                                                    <ItemStyle HorizontalAlign="Center" />
                                                                </radG:GridBoundColumn>
                                                                <radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
                                                                    SortExpression="END_TIME" UniqueName="END_TIME">
                                                                    <ItemStyle HorizontalAlign="Center" />
                                                                </radG:GridBoundColumn>
                                                            </Columns>
                                                            <EditFormSettings>
                                                                <EditColumn UniqueName="EditCommandColumn">
                                                                </EditColumn>
                                                            </EditFormSettings>
                                                            <HeaderStyle CssClass="HeaderNewAlt" />
                                                        </radG:GridTableView>
                                                    </DetailTables>
                                                    <EditFormSettings>
                                                        <EditColumn UniqueName="EditCommandColumn">
                                                        </EditColumn>
                                                    </EditFormSettings>
                                                </radG:GridTableView>
                                            </DetailTables>
                                            <EditFormSettings>
                                                <EditColumn UniqueName="EditCommandColumn">
                                                </EditColumn>
                                            </EditFormSettings>
                                            <HeaderStyle CssClass="HeaderNewAlt" />
                                        </radG:GridTableView>
                                    </DetailTables>
                                    <RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
                                        <HeaderStyle Width="20px" />
                                    </RowIndicatorColumn>
                                </MasterTableView>
                                <ItemStyle CssClass="Row" HorizontalAlign="Center" />
                                <HeaderStyle CssClass="Headerwhitespacewrap" />
                                <PagerStyle CssClass="Pager" Mode="NextPrevAndNumeric" Position="TopAndBottom" />
                                <FilterMenu HoverBackColor="LightSteelBlue" HoverBorderColor="Navy" NotSelectedImageUrl="~/RadControls/Grid/Skins/Default/NotSelectedMenu.gif"
                                    SelectColumnBackColor="Control" SelectedImageUrl="~/RadControls/Grid/Skins/Default/SelectedMenu.gif"
                                    TextColumnBackColor="Window"></FilterMenu>
                                <ClientSettings AllowExpandCollapse="True">
                                </ClientSettings>
                                <AlternatingItemStyle CssClass="Row" />
                            </radG:RadGrid>
                            <asp:sqldatasource id="XMS_CYCLE_TASK_B" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
                                providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand="SELECT A.TASK_ID, C.STATUS_NAME, A.SYSTEM_ID, B.SYSTEM_NAME,D.CYCLE_ID,A.START_TIME, A.END_TIME,D.DOCUMENT_COUNT,DECODE(D.ERRORF,NULL,'N','Y') ERROR_FLAG FROM XMS_CYCLE_TASK A,XMS_SYSTEM B,XMS_STATUS_CODES C,(SELECT BILL.CYCLE_ID,DOCUMENT_COUNT,ERR.CYCLE_ID AS ERRORF FROM (SELECT DISTINCT CYCLE_ID FROM CUSTOMER_DATA_SCHEMA.BILLING B,XMS_CYCLE_BATCH XCB WHERE XCB.BATCH_STATUS=2399 AND B.XMS_BATCH_ID=XCB.BATCH_ID) ERR, (SELECT CYCLE_ID,COUNT(1) DOCUMENT_COUNT FROM CUSTOMER_DATA_SCHEMA.BILLING GROUP BY CYCLE_ID) BILL WHERE ERR.CYCLE_ID(+)=BILL.CYCLE_ID) D WHERE D.CYCLE_ID = A.CYCLE_ID AND A.SYSTEM_ID = B.SYSTEM_ID AND A.TASK_STATUS = C.STATUS_CODE AND A.SYSTEM_ID IN SYSTEM_IDS ORDER BY TASK_ID DESC"
                                onselecting="XMS_CYCLE_TASK_B_Selecting">
                    </asp:sqldatasource>
                            <asp:sqldatasource id="XMS_CYCLE_DEST_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
                                providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand="SELECT A.DEST_ID, B.STATUS_NAME, A.TASK_ID, A.PRINT_DEST, A.POLICY_COUNT, A.START_TIME, A.END_TIME FROM XMS_CYCLE_DEST A INNER JOIN XMS_STATUS_CODES B ON A.DEST_STATUS = B.STATUS_CODE AND (A.TASK_ID = :TASK_ID) LEFT JOIN XMS_IMAGELOAD_TASK C ON A.DEST_ID = C.CYCLE_DEST_ID ORDER BY A.DEST_ID">
                    <SelectParameters>
<asp:Parameter Type="Decimal" Name="TASK_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
                            <asp:sqldatasource id="XMS_CYCLE_SUBTASK_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
                                providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand='SELECT A."SUBTASK_ID", B."STATUS_NAME", C."SUBSYSTEM_NAME", A."POLICY_COUNT", A."START_TIME", A."END_TIME" FROM "XMS_CYCLE_SUBTASK" A, "XMS_STATUS_CODES" B , "XMS_SUBSYSTEM" C WHERE A.SUBTASK_STATUS = B.STATUS_CODE AND A.SUBSYSTEM_ID = C.SUBSYSTEM_ID AND ("DEST_ID" = :DEST_ID) ORDER BY "SUBTASK_ID"'><SelectParameters>
<asp:Parameter Type="Decimal" Name="DEST_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
                            <asp:sqldatasource id="XMS_CYCLE_BATCH_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
                                providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand='SELECT "BATCH_ID", "STATUS_NAME", "POLICY_COUNT", "START_TIME", "END_TIME" FROM "XMS_CYCLE_BATCH" A, XMS_STATUS_CODES B WHERE A.BATCH_STATUS = B.STATUS_CODE AND ("SUBTASK_ID" = :SUBTASK_ID) ORDER BY "BATCH_ID"'><SelectParameters>
<asp:Parameter Type="Decimal" Name="SUBTASK_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
                             
                        </td>
                    </tr>
                    <tr>
                        <td style="border-right: #e9e9e9 1px solid; border-left: #e9e9e9 1px solid; border-bottom: #e9e9e9 1px solid;">
                            <table class="radgrid" cellpadding="2" cellspacing="5" style="border-top-style: none;
                                border-right-style: none; border-left-style: none; border-bottom-style: none;">
                                <tr>
                                    <td>
                                        T - Total
                                    </td>
                                    <td>
                                        F - Failed
                                    </td>
                                    <td>
                                        P - Paper
                                    </td>
                                    <td>
                                        E - Electronic
                                    </td>
                                    <td>
                                        R - Replacements
                                    </td>
                                    <td>
                                        C - Cost Disclosures
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                    <tr>
                        <td id="MinimizeZone">
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </form>
</table>
<UserControl:Footer ID="myFooter" runat="Server"></UserControl:Footer>

.cs
***

protected void Page_Load(object sender, System.EventArgs e)
       {
           // Put user code to initialize the page here

            if (PageUtility.CheckLevel2(this.Session))
            {
                RadGrid1.Columns.FindByUniqueName("STATUS_NAME_1").Visible = false;
                RadGrid1.Columns.FindByUniqueName("STATUS_NAME_2").Visible = true;
            }
            else
            {
                RadGrid1.Columns.FindByUniqueName("STATUS_NAME_2").Visible = false;
                RadGrid1.Columns.FindByUniqueName("STATUS_NAME_1").Visible = true;
            }

            if (!Page.IsPostBack)
            {
                Initialize();
            }
        }

        private void Initialize()
        {

            if (PageUtility.GetUserSite(this.Session) == "B")
            {
                rbSites.SelectedIndex = 0;
            }


            SiteSettings();

        }

       #region Web Form Designer generated code
       override protected void OnInit(EventArgs e)
       {
           //
           // CODEGEN: This call is required by the ASP.NET Web Form Designer.
           //
           InitializeComponent();
           base.OnInit(e);
       }

       /// <summary>
       /// Required method for Designer support - do not modify
       /// the contents of this method with the code editor.
       /// </summary>
       private void InitializeComponent()
       {

       }
       #endregion

        protected override void RaisePostBackEvent(IPostBackEventHandler sourceControl, string eventArgument)
        {
            base.RaisePostBackEvent(sourceControl, eventArgument);

            if (sourceControl == this.RadGrid1)
            {
                RadGrid1.Rebind();
            }


        }

        protected void rbSystems_SelectedIndexChanged(object sender, EventArgs e)
        {
            SiteSettings();

            RadGrid1.DataBind();
        }



        protected void XMS_CYCLE_TASK_B_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            string strArgValue = "";
            if (rbSites.SelectedValue == "('B')")
            {
                strArgValue = "('B')";
            }


            string strQuery = e.Command.CommandText.Replace("SYSTEM_IDS", strArgValue);

            e.Command.CommandText = strQuery;
        }

        protected void rbSites_SelectedIndexChanged(object sender, EventArgs e)
        {
            SiteSettings();

            RadGrid1.DataBind();

        }

        private void SiteSettings()
        {
            if (rbSites.SelectedValue == "('B')")
            {
                RadGrid1.Visible = true;
                btnRefreshB.Visible = true;
            }

        }

Grid

answered on 10 Mar 2015