[Solved] How to hide Column In Telerik RadGrid which all cells are null

[Sanjeewa]

I was new to telerik.
I want to hide columns in radgridview which column all cells are null values by programmatically.

thanks

[Dimitar]

Hello Sanjeewa,

Thank you for writing.

To achieve this you need to iterate all rows and columns see if all values are null:

private void RadButton1_Click(object sender, EventArgs e)
{
    foreach (var col in radGridView1.Columns)
    {
        bool valueFound = false;
        foreach (var row in radGridView1.Rows)
        {
            if (row.Cells[col.Name].Value != null && row.Cells[col.Name].Value != DBNull.Value)
            {
                valueFound = true;
                break;
            }
        }
        col.IsVisible = valueFound;
    }

}

I have noticed that this question is posted twice and I have deleted the other post. 

I hope this will be useful. Let me know if you have additional questions.

Regards,
Dimitar
Telerik by Progress