Student Monthly Fees Table in SQL Server

Question

I want to create a student monthly fees table in SQL Server and display the fees for all students in a data grid View. How can i chieve that. The Datagrid view should display data as Jan - Dec along with name and total. Thanks for the help.

Nilesh Shah · Answer

may be you need a master-detail gridview in which the months for Jan to Dec are master rows which show totals and in that once you expand the child rows are the student rows with individual fees. have a look at below code you may have to program as per your tables: https://www.codeproject.com/Articles/848637/Nested-DataGridView-in-windows-forms-csharp https://www.codeproject.com/Articles/9986/Using-the-DataGrid-Control