how to get the hidden column value

[Kranthi]

Hi All

i have a requirement to get the hidden column value for the rows which checkbox has been selected, can anyone come up with a good solution to complete this thing  may be client side or server side ... 

my rad grid 

            <telerik:RadGrid ID="M" runat="server" Width="99%" AllowPaging="True" EnableViewState="False"
                GridLines="None" meta:resourcekey="MResource1" AllowFilteringByColumn="true"
                OnInit="GridControl_Init" EnableLinqExpressions="false" 
                EnableEmbeddedSkins="false" AutoGenerateColumns="False">
                <HeaderContextMenu EnableEmbeddedSkins="True">
                </HeaderContextMenu>
                <FilterMenu Skin="Nediso" EnableEmbeddedSkins="false">
                </FilterMenu>
                <PagerStyle Mode="NextPrevAndNumeric" Position="TopAndBottom" AlwaysVisible="true" />
                <MasterTableView Width="100%" EnableViewState="False" AllowFilteringByColumn="true">
                   <Columns>  


                   <telerik:GridTemplateColumn UniqueName="CheckBoxTemplateColumn" AllowFiltering="false">
                   <HeaderStyle Width="3%" HorizontalAlign="Justify" />
                    <ItemStyle Width="3%" HorizontalAlign="Justify" />
                            <HeaderTemplate>
                             <asp:CheckBox id="headerChkbox"  runat="server" onclick="SelectAll(this)"></asp:CheckBox>
                            </HeaderTemplate>
                            <ItemTemplate>
                                <asp:CheckBox id="CheckBox1" runat="server"></asp:CheckBox>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                   
                     <telerik:GridBoundColumn DataField="TOKEN" Visible="false" UniqueName="TOKEN" ReadOnly="true" >
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="FIRST NAME" HeaderText="FIRST NAME" UniqueName="FIRST NAME">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="LAST NAME" HeaderText="LAST NAME" UniqueName="LAST NAME">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="STATUS" HeaderText="STATUS" UniqueName="STATUS">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="DESIGNATION" HeaderText="DESIGNATION" UniqueName="DESIGNATION">
                    </telerik:GridBoundColumn>
                    </Columns>
                    <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" Position="TopAndBottom" />
                    
                </MasterTableView>
                <ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnableRowHoverStyle="True">
                    <Resizing AllowColumnResize="True" />
                    <Selecting AllowRowSelect="True" />                    
                    <ClientEvents OnFilterMenuShowing="OnFilterMenuShowing"></ClientEvents> 
                    </ClientSettings>
                <FilterMenu EnableTheming="True">
                    <CollapseAnimation Type="None" />
                    <ExpandAnimation Type="None" />
                </FilterMenu>
            </telerik:RadGrid>

[Shinu]

Hello,

One suggestion is you can set the Display property of the column as false and then get the column value. Try the following javascript to acess hidden column value.
aspx:

<telerik:GridBoundColumn UniqueName="EmployeeID" Display="false"  DataField="EmployeeID" HeaderText="EmployeeID">
</telerik:GridBoundColumn>

JS:

function check() {
 var grid = $find("<%=RadGrid1.ClientID %>");
 var masterTable = grid.get_masterTableView();
 var row = masterTable.get_dataItems()[0];
 var cell = masterTable.getCellByColumnUniqueName(row, "TOKEN");
 alert(cell.innerHTML);
}

Thanks,
Shinu.

[Kostadin]

Hello Kranthi,

You can also do it by leaving the Visible property to false. For this purpose you should add the following javascript:

function RowSelected(sender, eventArgs) {
            
            var grid = sender;
            var MasterTable = grid.get_masterTableView();
            var row = MasterTable.get_dataItems()[eventArgs.get_itemIndexHierarchical()];
            var cell = row.getDataKeyValue("TOKEN");
            //here cell.innerHTML holds the value of the cell  
        }

You should also add ClientDataKeyNames property in MasterTableView.

<MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1" ClientDataKeyNames="TOKEN">

You will find more information here: http://www.telerik.com/help/aspnet-ajax/grid-extract-key-values-client-side.html

All the best,
Kostadin
the Telerik team

[Adam]

How can I do this server-side..??  I have a number of hidden fields..

I can't seem to get the text value other than "&nbsp;"

I've just upgraded from version 2011.x to 2013.3.1324.45..  my previous code no longer seems to work as expected. :

1.For Each i As GridDataItem In grdItems.MasterTableView.GetSelectedItems()
2.  If i.Selected Then
3.    Dim iVal As GridDataItem = i
4.    Dim IDVal as string = iVal("MER_ItemSummaryID").Text
5.
6.  end if
7.next

I've set the DataKeyNames value for the MasterTableView and can get the value using :
iVal.KeyValues

This returns : "{MER_ItemSummaryID:"21694"}"

I thought there might be a nicer way to retrieve them than parsing a text value.

Thanks

[Adam]

Sorry..  I hate it when you search for hours for a solution, you end up finally just posting to a forum like this one or SO, then literally 5 minutes later find the solution you require..

I just changed my code slightly to the following:

For Each i As GridDataItem In grdItems.MasterTableView.GetSelectedItems()
    If i.Selected Then
        Dim iVal As GridDataItem = i
        Dim IDVal as string = iVal.GetDataKeyValue("MER_ItemSummaryID").ToString()
    End If
Next

[Princy]

Hi Adam,

If you have hidden columns for your grid, you can access them in the code-behind either through DataKeyValue or if you set the Display as false you may access the columns in server side. Please take a look at the below code.

ASPX:

<MasterTableView DataKeyNames="OrderID">
 <Columns>
  <telerik:GridBoundColumn DataField="ShipCity" HeaderText="ShipCity" UniqueName="ShipCity" Display="false" />
 </Columns>

VB:

If TypeOf e.Item Is GridDataItem Then
    Dim items As GridDataItem = DirectCast(e.Item, GridDataItem)
    Dim id As String = items.GetDataKeyValue("OrderID").ToString()
    Dim value As String = items("ShipCIty").Text
End If

Thanks,
Princy

[Amjad]

I have this problem that when  I get the hidden field value it returns &nbsp; when its empty.

how can I get around this issue?

please note that I can put if statement to avoid this but I need better solution

[Kostadin]

Hi Amjad,

Note that when a columns is hidden by setting Visible to false it will set &nbsp; text to its cell. I am afraid if you need to remove it you have to manually do that on ItemDataBound event handler by checking the cell text.

Regards,
Kostadin
Telerik

 

 

[Christophorus Donny]

Hi
don't use Visible="false" on your GridBoundColumn/GridNumericColumn.
try this to hidden your collumn and still get the value :

RadGrid1.MasterTableView.GetColumn("UniqueName").Display = False

Thanks,
Hsn