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 4:16am
Edited 2-Feb-13 4:20am
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
Your Filters
Interested
Ignored
     
0 Guruprasad.K.Basavaraju 490
1 Sergey Alexandrovich Kryukov 316
2 Shai Vashdi 264
3 OriginalGriff 250
4 praveen_07 115
0 Sergey Alexandrovich Kryukov 9,185
1 OriginalGriff 5,315
2 Peter Leow 4,040
3 Maciej Los 3,535
4 Abhinav S 3,308


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 2 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid