Showing monthly info in data control

[cara_little]

Hello,
I'm trying to show monthly summary info in some type of data control
like so:

Jan Feb Mar Jun
Apples 10 15 20 25
Oranges 5 3 6 10
Bananas 8 7 4 9

so that it shows the number of apples bought in Jan, etc.

When I pull the data from the database, I'm using a group by so that
each record has the total apples, total oranges and total bananas for
the specific month. So the data record looks like so:
NumApples NumOranges NumBananas Month
10 5 8 1

What's the easiest way to get that data to display correctly with the
default column on the left, the header columns and the data showing in
columns per month - I've been playing with the datagrid and datalist
and can't seem to get it to work - but then it's been a long day so
hopefully I'm missing something easy.

 

[Cor Ligthert]

Cara,

Maybe can this reflection sample that I once made help you which is in this
message.

http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb/msg/dee5b245d3f5ce7e?hl=en

I hope this helps,

Cor