he database result is as follows
DATE code class1 class2 class3
1/8/10 M1 10 20 30
3/8/10 V2 20 30 10
1/8/10 H1 1 2 3
7/8/10 !
!
8/8/10 !M2 5 5 5
3/8/10 B2 4 4 4
1/8/10 V1 3 7 3
THE OUTPUT SHOULD BE AS FOLLOWS:-
DATE M1 M2 H1 V1
C1 C2 C3 C1 C2 C3 C1 C2 C3 C1 C2 C3
1/8/10 10 20 30 5 5 5 1 2 3 3 7 3
BASED ON PARTICULAR DATE AND CODE THE DATA FROM ROWS IS DISPLAY IN THIS WAY BASED WITH MULTIPLE ROWS
CAN I GET THE QUERY TO RETRIEVE INTO THE GRID IN VB.NET USING ORACLE (TOAD)