Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
any one help me ---gird view control
Kumaran P
Mar 11 2017 2:13 PM
228
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
can any say how to remove the duplicates in a text file
database conversion