Click here to Skip to main content
12,505,591 members (53,277 online)

How to Show 2 Table Data to DataGridView. 1 Table Data need Header Text

Navas Khanj asked:

Open original thread
Hi All Please Help Me...
I have 3 Table View to DataGridView


This Table Data Want Display

Table1 (StudentDetails)			
Regno	Name	Class	Section
A100	Raja	I	A
A200	Ravi	I	A

This Table Filed Want Display To DataGridView Column

Table2(Fees Structure)
Class	FeeType	Total Amount	
I	Jan	1500	
I	Feb	2500	
I	Mar	1500	
I	Apr	3000	
I	Other	500


This Talbe Data Show to DGV
Table3 ( FeesTrans)
Regno 	Sname	Class	FeeType	Amount
A100	Raja	I	Jan	1000
A100	Raja	I	Jan	500
A100	Raja	I	Feb	2500
A100	Raja	I	Other	500
A200	Ravi	I	Jan	1500
A200	Ravi	I	Other	500

I want DataGridView Like This


Regno	Sname	Class	Section	Jan	Feb	Mar	Apr	Other	Total
A100	Raja	I	A	1500	500	0	0	500	2500
A200	Ravi	I	A	1500	0	0	0	500	200
Tags: VB, VB.NET

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web01 | 2.8.160927.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2016
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