[Solved] Hide unused columns

[Carsten Højgaard]

I’m looking for a way to hide columns in the RadGrid that does not contain any data.

Anyone got an idea on how to do this without iterating the whole grid?

[Princy]

Hi,

Try the following code snippet to loop through each item in the Grid.

CS:

 protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
        foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
        {
            foreach (GridColumn col in RadGrid1.MasterTableView.RenderColumns)
            {
                string strtxt = item[col.UniqueName].Text.ToString();
                if (strtxt == " ")
                {
                    item[col.UniqueName].Visible = false;
                }
            }
        }
    }

Thanks
Princy.

[Carsten Højgaard]

Hi Princy

Thank you for your quick reply… and of cause the code ;)
It works perfectly. To hide the column, I had to change:

item[col.UniqueName].Visible = false;

 
to

col.Display = false;

Thanks again!
Carsten