Click here to Skip to main content
11,710,423 members (80,764 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: VB.NET
How to Display DGV Column Wise .

My FeeType Data Come to DGV Header Text and FeeAmout Want to show Header Related..

Class	FeeType	FeeAmount
I	Jan	400
I	Feb	300
I	Mar	700
II	Jan	400
II 	Other	200

I Want DGV Like THIs. I Selected "I Class" Then Display Like This

Jan	Feb	Mar
400	300	700

I Select "II" Class

Jan	Other	
400	200

Please Tell me some idea for that how can i do ..

[edit]Code block added - OriginalGriff[/edit]
Posted 2-Feb-13 4:16am
Edited 2-Feb-13 4:20am
(no name)1.3M
Sandeep Mewara at 5-Feb-13 12:37pm
AFAIK, you need to have separate queries based on the selection done to have proper pivot query run and retrieve data.

Start with one, get class I in place and then extend it.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 524
1 OriginalGriff 245
2 Peter Leow 194
3 Abhinav S 102
4 Suvendu Shekhar Giri 95
0 OriginalGriff 9,428
1 Sergey Alexandrovich Kryukov 9,037
2 CPallini 5,189
3 Maciej Los 4,991
4 Mika Wendelius 3,856

Advertise | Privacy | Mobile
Web01 | 2.8.150819.1 | Last Updated 2 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100