3 Table Show to DataGirdView

Revision 1
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