Click here to Skip to main content
12,757,627 members (36,489 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB 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
Updated 2-Feb-13 5:20am
v2
Comments
Sandeep Mewara 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
Top Experts
Last 24hrsThis month


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