ASP.NET Bound Columns

[methexandude]

Hi,
I have recently started developing ASP.net applications using VB.net.
Well, I created this huge query to retrieve data from SQL Server and create a pivot table, which means I'm creating columns of values. It all works fine and I have a datagrid which displays the data like the way I want.

I'm using Bound columns where I'm defining the Name and Datafields to show for my datagrid columns. All of this was the easy part.

Now, my query creates 55 columns which makes my data grid look like an I-Max screen (weeeheee). To shorten the looks of the grid what I can do is show columns which has a value > 0 and do not show the ones which do not. As I review the data in my I MAX grid there are loads of columns which have zeros and there visibility of no use to me. However, I cannot have zero values columns totally not show in my grid as they might have values based on selection made(business logic).

So, how can I make something like this.... in my code behind

IF <asp:boundcolumn headertext="3RT " datafield="3RT " /> < 0 THEN <asp:boundcolumn headertext="3RT FEE " datafield="Z510" /> .Visible = false

I know the above does not make sense as coding goes but this is just to show what I wanna do in the terms of logic. Remember I have 55 columns like that and I wanna have the same condition for all of 'em.

I'll appreciate any help.
Thanks.