ASP.net Hide columns inn a GridView where are cells for that column are blank

Hi

In my ASP.net web app I want to load data to a GridView and hide any columns where all data is blank or null.
I know how to hide a columns in the  Row_Created event but I need to check all the data before I know that it is blank.
Should I loop through a datatable first? What would the code look like for this?


Thanks