Click here to Skip to main content
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
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
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