Loading

Student Monthly Fees Table in SQL Server

Stark

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted 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
+1