Remove column from Radgrid

[Shyam]

How to remove dynamically created column from Radgrid.

[Jayesh Goyani]

Hello,

protected void RadGrid1_PreRender(object sender, EventArgs e)
  {
     foreach(GridColumn column in  RadGrid1.Columns)
     {
         if (column.UniqueName == "YourColumnUniqueNane")
         {
             column.Visible = false;
         }
     }
  }

Thanks,
Jayesh Goyani

[Shyam]

Thanks Jayesh.

Can we hide column depending upon data. If I don't have data then just empty column is displayed so how do I hide it.

[Jayesh Goyani]

Hello,

List<GridDataItem> items = (from item in RadGrid1.MasterTableView.Items.Cast<GridDataItem>()
                                        where string.IsNullOrEmpty(item["ColumnUniqueName"].Text)
                                        select item).ToList();

            if (items != null && items.Count > 0)
            {
                foreach (GridColumn column in RadGrid1.Columns)
                {
                    if (column.UniqueName == "YourColumnUniqueNane")
                    {
                        column.Visible = false;
                    }
                }
            }

Thanks,
Jayesh Goyani

[Shyam]

Thanks Again. :)  I think it will work for me.
One more question  Columns.Remove() or  Columns.RemoveAt()   will do my work or not. I have tried both the methods but not found any luck.

[Jayesh Goyani]

Hello,

If you need to remove a column from a Telerik RadGrid at runtime, subscribe to the grid's DataBound event, find the column by its unique name, and set its display property to false.  This is the correct way to do this without breaking the filter functionality.  For a long time I was subscribing to the grid's ItemDataBound event and hiding each dataitem for the column- only now did I realize that the filter was broken by doing it that way.

 

Example:

 

    protected void rgPartDispositionHistory_DataBound(object sender, EventArgs e)
    {
        rgPartDispositionHistory.MasterTableView.Columns.FindByUniqueName("PeopleSoftId").Display = true;
    }

Thanks,
Jayesh Goyani

[Shyam]

I really appreciate your help. Your solution gives me direction to solve my problem.