Not showing Empty GridBoundColumns

[ervin]

Hi guys,

I have a short question.
I would like to set GridBoundColumns visibility to false if the column is empty. Can you please help me?

Thanks,
Ervin

[Shinu]

Hello Ervin,

You can achieve this by iterating either in RadGrid.ItemDataBound or in RadGrid.PreRender. And hide the required column by RadGrid.MasterTableView.RenderColumns collection or by using the MasterTableView.GetColumn() method.
C#:

flag=0;
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem DataItem= e.Item;
            if (DataItem["FirstName"] !="")
            {
                flag == 1;
            }
        }
    }
     protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
        if (flag == 0)
        {
            RadGrid1.MasterTableView.GetColumn("FirstName").Display = false;
        }
    }

 

Thanks,
Shinu