FeesMaster : Table Data Reg no Class Section Sname FeeType FeeAmount A600 I A BBBB Team-1 650 A700 I A DSDSDSDSD Team-1 750 A900 I A PPPP Team-1 750 A600 I A BBBB Jan 650 A700 I A DSDSDSDSD Jan 650 A900 I A PPPP Jan 650 Fees_Transaction Table Data Regno ST_Name Class Section Amount_Paid FeeType A600 BBBB I A 500 Team-1 A900 PPPP I A 750 Team-1 A700 DSDSDSDSD I A 500 Team-1 A700 DSDSDSDSD I A 250 Team-1 A700 DSDSDSDSD I A 300 Jan A700 DSDSDSDSD I A 350 Jan A600 BBBB I A 150 Team-1 A900 PPPP I A 200 Jan I am Using Code Class Section and FeeType Same Means Display I want to DataGridView Like This Reg no ST_Name Amount_Paid FeeAmount FeeType Class A600 BBBB 650 1300 TOTAL I A700 DSDSDSDSD 1400 1400 TOTAL I A900 PPPP 950 1400 TOTAL I

Answer

2 Table Join and Calculate Total amount Show To DatagridView

Navas Khanj

11y

1.3k

FeesMaster : Table Data
Reg no	Class	Section	Sname	FeeType	FeeAmount
A600	I	A	BBBB	Team-1	650
A700	I	A	DSDSDSDSD	Team-1	750
A900	I	A	PPPP	Team-1	750
A600	I	A	BBBB	Jan	650
A700	I	A	DSDSDSDSD	Jan	650
A900	I	A	PPPP	Jan	650

Fees_Transaction Table Data
Regno	ST_Name	Class	Section	Amount_Paid	FeeType
A600	BBBB	I	A	500	Team-1
A900	PPPP	I	A	750	Team-1
A700	DSDSDSDSD	I	A	500	Team-1
A700	DSDSDSDSD	I	A	250	Team-1
A700	DSDSDSDSD	I	A	300	Jan
A700	DSDSDSDSD	I	A	350	Jan
A600	BBBB	I	A	150	Team-1
A900	PPPP	I	A	200	Jan

I am Using Code
Class , Section and FeeType Same Means Display I want to DataGridView Like This

Reg no	ST_Name	Amount_Paid	FeeAmount	FeeType	Class

A600	BBBB	650	1300	TOTAL	I
A700	DSDSDSDSD	1400	1400	TOTAL	I
A900	PPPP	950	1400	TOTAL	I