hiding DataGrid column with empty/null values

Jan 26, 2010 at 5:35 PM

I'm using a DataGrid in a testing tool - it gets loaded with a large set of values that can contain over a hundred columns.  In many cases over half the columns are empty or contain null/zero values.  Is there a way I can get DataGrid to hide these columns so that my dataset is more readable?

I'm using AutoGenerated columns, and I don't know ahead of time which columns are null so I can't hide them at design time.