Access to underlying data

[Bob Fenton]

Hi

Is it possible to access data which is in the data table bound to the grid but where the grid column for that data has a visible property of false?

For example, I want to do some custom formatting on Cell A based on the value of Cell B, where the column for Cell B's values is not visible in the grid.

Thanks

Bob

[Shinu]

Hello Bob,

It is possible to access the cell value even if it's visible property is set to false. Check out the following code snippet.

ASPX:

 <telerik:GridBoundColumn UniqueName="FirstName" DataField="FirstName" HeaderText="FirstName">
 </telerik:GridBoundColumn>
 <telerik:GridBoundColumn UniqueName="user_role" DataField="user_role" HeaderText="user_role" Visible="false">
 </telerik:GridBoundColumn>

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            if (item["user_role"].Text == "admin")
            {
                item["FirstName"].Text = "New Name";
            }
        }
    }

You can also refer the following documentation which describes how to access cells and rows in a grid.
Accessing cells and rows



Regards,
Shinu.

[Bob Fenton]

Perfect!

Thanks very much.

Bob