[Solved] Hide Empty Columns

[Drew]

Hi,

I've produced a GridView which shows Student results over a few years. The issue I have is some years, the students may not have taken in the test, therefore a column will end up with no values. (See Screenshot).

I'm wondering if it's possible to detect and hide these empty columns?

Regards,
Drew

[Maya]

Hi Drew,

You may run through the Items collection of the grid and check if all of them have empty value for a particular property. Once you find this out, you may set the corresponding columns' IsVisible property to "False".
 

All the best,
Maya
the Telerik team

[Drew]

Thanks, that was the idea I had. However I'm currently unsure of how to do this as there is no GridView.Rows property.

Obviously I need to loop through each column and check if any row has a value.

ie.
For Each Col in GridView.Columns
' Check if Any Row Has a Value
Next

How can I now loop through each row within a column? There is no Column.Row(i) Property etc.

Thanks,
Drew

[Maya]

Hello Drew,

You may use the Items collection of the RadGridView. For example, if your Business Object is Club and it has a property - Name, you can check if all the names of the items are null as follows:

foreach(Club club in this.clubsGrid.Items)
{
    if(club.Name == null)
    {
    }
}

 

All the best,
Maya
the Telerik team

[Drew]

Thankyou Maya. I must have missed the Items collection!

Regards,
Drew