Get the value of a database column that is not shown in the grid

[a]

When databinding a grid to a SqlDataSource I'm wondering the best way to get the value of a database column that is not shown in the grid, but that is returned from the database for the corresponding row in the grid. 

I have a Delete GridButtonColumn that I want to show or hide for each row based on a value from the database. This type of column doesn't allow databinding, so I need to programmatically get at the database column value in the RadGrid ItemDataBound event to do the button hiding.

[Princy]

Hi,

You can set the DataKeyName property of the grid as the required datafield and then retrieve its value as shown in the code below.
aspx:

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" >
   <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="Age">
     .....

cs:

 if (e.Item is GridDataItem)
        {
          GridDataItem dataItem = (GridDataItem)e.Item;
          string key = dataItem.GetDataKeyValue("Age").ToString();
          // code to hide/show button
        }

Thanks
Princy.

[a]

Thank you. Does modifying the DataKeyName value to include a column that is not part of the primary key impact insert/update/delete operations? I was thinking that the DataKeyName was only supposed to be the primary key of the database and that it was needed to enable this insert/update/delete functionality.