hi all,
please help me i want girdview for below summary using sql db with storeprocedure
i have attached my example
| | SQl DATA | | |
| | | | |
| S.no | Name | INTEREST | case |
| 1 | RAJA | MANGO | 1 |
| 2 | RANI | APPLE | 2 |
| 3 | RAJA | MANGO | 3 |
| 4 | RANI | APPLE | 5 |
| 5 | KANNAN | ORANGE | 5 |
| 6 | KUMARAN | APPLE-1 | 8 |
| 7 | GURU | MANGO-1 | 5 |
| 8 | KAMAL | ORANGE-1 | 8 |
| 9 | RAJAAN | APPLE | 4 |
| 10 | RUPI | APPLE | 3 |
i want below summary for gridview
| Name | MANGO | APPLE | ORANGE | APPLE-1 | MANGO-1 | ORANGE-1 | TOTAL |
| GURU | 0 | 0 | 0 | 0 | 5 | 0 | 5 |
| KAMAL | 0 | 0 | 0 | 0 | 0 | 8 | 8 |
| KANNAN | 0 | 5 | 0 | 0 | 0 | 0 | 5 |
| KUMARAN | 0 | 0 | 0 | 8 | 0 | 0 | 8 |
| RAJA | 0 | 0 | 4 | 0 | 0 | 0 | 4 |
| RAJAAN | 4 | 0 | 0 | 0 | 0 | 0 | 4 |
| RANI | 7 | 0 | 0 | 0 | 0 | 0 | 7 |
| RUPI | 3 | 0 | 0 | 0 | 0 | 0 | 3 |
| Grand Total | 14 | 5 | 4 | 8 | 5 | 8 | 44 |