Telerik RadGrid (using Batch Edit) Hide / Disable Column Based on Another Column's Value

Question

I'm trying to get RadGrid to conditionally hide or disable a field when it is in edit mode based on the value of another field.

I have been able to get this to work when the grid displays the list of items, but once the grid enters edit mode, the columns display ...

I am using OnItemDataBound to successfully conditionally display during the initial load, but setting the items when the user clicks a row to get it into batch mode is not working.

Note: PValue and CValue and in GridTemplateColumns, as is CardStatus.

public void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
foreach (GridDataItem item in RadGrid1.Items)
       {
          string BoundColumnValue = item["CardStatus"].Text; // accessing    GridBoundColumn value using ColumnUniqueName
            string BoundColumnValue2 = item["CValue"].Text;
            TextBox txtbx = (TextBox)item.FindControl("CardStatus");
            Label numlb = (Label)item.FindControl("CardValue");

            if (txtbx.Text.Equals("True"))
            {
                txtbx.ForeColor = Color.Red;

                numlb.Enabled = false;
                numlb.BackColor = Color.Yellow;
                numlb.ForeColor = Color.Red;
               //Just testing to see if it would evaluate
            }
            else
            {
                txtbx.ForeColor = Color.Beige;
            }
            //string TemplateColumnValue = lb.Text;// accessing Label Text.
        }

        foreach (GridEditableItem item in RadGrid1.EditItems)
        {
            string BoundColumnValue = item["CardStatus"].Text; // accessing GridBoundColumn value using ColumnUniqueName
            string BoundColumnValue2 = item["CValue"].Text;
            TextBox txtbx = (TextBox)item.FindControl("CardStatus");
            if (txtbx.Text.Equals("True"))
            {
                txtbx.ForeColor = Color.Red;

                //numTxt.BackColor = Color.Yellow;
                //numTxt.ForeColor = Color.Red;
            }
            else
            {
                txtbx.ForeColor = Color.Beige;
            }
}
}

I just need to be able to selectively prevent data entry in a column

The ASPX source is below:

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticUpdates="true" Height="930px" DataSourceID="SqlDataSource4" CellSpacing="0" GridLines="None" Width="640px" OnItemDataBound="RadGrid1_ItemDataBound" OnItemCreated="RadGrid1_ItemCreated" OnBatchEditCommand="RadGrid1_BatchEditCommand1"  Skin="WebBlue">
                        <ClientSettings>
                            <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                        </ClientSettings>
                        <MasterTableView AutoGenerateColumns="False" EditMode="Batch" Width="620px" CommandItemDisplay="TopAndBottom" DataSourceID="SqlDataSource4" DataKeyNames="CountKey">
                            <CommandItemSettings ExportToPdfText="Export to PDF" ShowSaveChangesButton="true" ShowRefreshButton="false" ShowAddNewRecordButton="false"></CommandItemSettings>
                            <BatchEditingSettings OpenEditingEvent="Click"  EditType="Row"  />

                            <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
                                <HeaderStyle Width="20px"></HeaderStyle>
                            </RowIndicatorColumn>

                            <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
                                <HeaderStyle Width="20px"></HeaderStyle>
                            </ExpandCollapseColumn>

                            <EditFormSettings>
                                <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
                            </EditFormSettings>

                            <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>
                            <Columns>
                                <telerik:GridBoundColumn DataField="Pcolumn" ItemStyle-Width="75px" ReadOnly="true" Visible="false" DataType="System.Int32" FilterControlAltText="Filter Pcolumn column" HeaderText="Pcolumn" SortExpression="Pcolumn" UniqueName="Pcolumn">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="Row" ReadOnly="true" Visible="false" DataType="System.Int32" FilterControlAltText="Filter Row column" HeaderText="Row" SortExpression="Row" UniqueName="Row">
                                </telerik:GridBoundColumn>
                                <telerik:GridTemplateColumn ColumnEditorID="PValue" HeaderText="Pattern" DataField="PValue" UniqueName="PValue" ItemStyle-Width="75px" HeaderStyle-Width="75px">

                                    <EditItemTemplate>
                                        <telerik:RadNumericTextBox ID="PValue" Width="50px" runat="server" MaxLength="1" MaxValue="9" NumberFormat-DecimalDigits="0" Text='<%# Bind("PValue") %>'></telerik:RadNumericTextBox>
                                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="PValue"  ErrorMessage="<br/>Required (0-9) Only)!" SetFocusOnError="true"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="PValue" Width="50px" runat="server" Text='<%# Bind("PValue") %>'></asp:Label>
                                    </ItemTemplate>

                                </telerik:GridTemplateColumn>

                                <telerik:GridTemplateColumn ColumnEditorID="CValue" DataField="CValue" HeaderText="Card" UniqueName="CValue" ItemStyle-Width="75px" HeaderStyle-Width="75px">

                                    <EditItemTemplate>

                                        <telerik:RadNumericTextBox ID="CValue" Width="50px" AllowOutOfRangeAutoCorrect="false"  runat="server" MaxLength="1" MaxValue="1" NumberFormat-DecimalDigits="0" Text='<%# Bind("CValue") %>'></telerik:RadNumericTextBox>
                                        <asp:RequiredFieldValidator runat="server" ControlToValidate="CValue" ErrorMessage="<br />Required (0-1 Only)!" SetFocusOnError="true"></asp:RequiredFieldValidator>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CValue" Width="50px" runat="server" Text='<%# Bind("CValue") %>'></asp:Label>
                                    </ItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridBoundColumn DataField="DateEdited" ReadOnly="true" Visible="false" DataType="System.DateTime" FilterControlAltText="Filter DateEdited column" HeaderText="DateEdited" SortExpression="DateEdited" UniqueName="DateEdited">
                                </telerik:GridBoundColumn>
                                <telerik:GridTemplateColumn UniqueName="CardStatus" DataField="CardStatus" ItemStyle-Width="50px" HeaderStyle-Width="50px">
                                <ItemTemplate>
                              <asp:TextBox ID="CardStatus" Width="10px"  runat="server" Text='<%# Bind("CardStatus") %>'></asp:TextBox>           
                                </ItemTemplate>
                                    <EditItemTemplate>
      <asp:TextBox ID="CardStatus" Width="10px"  runat="server" Text='<%# Bind("CardStatus") %>'></asp:TextBox>           

                                    </EditItemTemplate>

                            </telerik:GridTemplateColumn>

                            </Columns>

                        </MasterTableView>

                        <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>

                        <FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:RadGrid>

Any help / workarounds would be appreciated ... again, "just" need to prevent editing in the CValue column when the CardStatus value is true (bit field) ... using batch mode (using another solution isn't an option now).

Thanks

Larry

Answer 1

Well, this doesn't answer the Telerik question, but ended up doing this with the MS GridView, using the tutorial here: http://msdn.microsoft.com/en-us/library/aa992036(v=vs.90).aspx.

Also was able to customize, and detect hidden grid fields, and hide cells (and disable validators) based on the hidden field's condition.

Added the following code in the RowDataBound event of the gridview:

DataRowView drv = (DataRowView)e.Row.DataItem;

            if (drv["Status"].Equals(true))
            {
                // Find the order of the cell 
                e.Row.Cells[5].CssClass = "hiddencol"; // using the display: none style

                // Find the Validator control in the template column
                RequiredFieldValidator reqF = (RequiredFieldValidator)e.Row.Cells[5].FindControl("RequiredFieldValidator1");
                reqF.Enabled = false;
            }
            else
            {

            }