Hide Columns - Several Detail Tables at a single hierarchy level

[Aret]

Greetings,

I have a radgrid where its datasource is bound from an XML output.  It has multiple hierarchy levels and has (auto genearted columns = true).  On the  2nd level of the hierarchy there are several details tables that automatically get binded. (Please reference image below).  However, there are columns which get auto generated displaying the ID's for the detail tables.  My goal is to programmatically hide all the ID's in all detail tables.   I can hide the CusomterID programmatically using the following code below: 

For Each item As GridDataItem In Radgrid_CRGList.Items        
               
       ''Root Level of Radgrid
         Radgrid_CRGList.MasterTableView.GetColumnSafe("OrderID").Visible = False        

     ''2nd Level of Radgrid - 1st Detail Table
      Radgrid_CRGList.MasterTableView.DetailTables(0).GetColumnSafe("CustomerID").Visible = False        
   
    ''2nd Level of RadGrid - 2nd Detail Table                                
'''  Place code here to hide EmployeeID ''

Next 


The issue is that I can't figure out the code to hide the EmployeeID in the 2nd details table on the same hierarchy level of the radgrid.  Please Help!

[Aret]

here is the picture of my radgrid relating to my post.

[Princy]

Hi Aret,

Please try the following code snippet to hide the columns in detail table.

VB:

Protected Sub RadGrid1_PreRender(sender As Object, e As EventArgs)
    RadGrid1.MasterTableView.GetColumn("OrderID").Visible = False
    'Access first detailtable in 2nd level
    RadGrid1.MasterTableView.DetailTables(0).GetColumn("CustomerID").Visible = False
    'Access second detailtable in 2nd level
    RadGrid1.MasterTableView.DetailTables(1).GetColumn("EmployeeID").Visible = False
    RadGrid1.Rebind()
End Sub

Thanks,
Princy

[Aret]

Thank You! Thank Worked