Click here to Skip to main content
11,495,049 members (54,294 online)
Rate this: bad
good
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..

Table
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 5:16am
Edited 2-Feb-13 5:20am
(no name)1.3M
v2
Comments
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 Dnyaneshwar@Pune 692
1 CHill60 318
2 Sascha Lefèvre 280
3 Sergey Alexandrovich Kryukov 255
4 Nakul Chaudhari 236
0 Sergey Alexandrovich Kryukov 10,307
1 OriginalGriff 8,821
2 Sascha Lefèvre 3,889
3 Maciej Los 3,412
4 Richard Deeming 2,560


Advertise | Privacy | Mobile
Web04 | 2.8.150520.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