any one help me ---gird view control

Question

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