Click here to Skip to main content
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.2M
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 Maciej Los 337
1 DamithSL 305
2 ridoy 264
3 OriginalGriff 208
4 George Jonsson 140
0 OriginalGriff 7,968
1 DamithSL 6,179
2 Sergey Alexandrovich Kryukov 5,524
3 Maciej Los 5,438
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 2 Feb 2013
Copyright © CodeProject, 1999-2014
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