How to Categorize Data in a datagrid
-
Hi guys I have the following tables. The student info table contains info on students, the grade info hold info on their classes or grades & the billinfo table holds info on each students fees.
Tables studentInfo ----------- StudentId(PK) studentName gradeId (FK) GradeInfo ---------- gradeId(PK) GradeName BillInfo ----------- childId(FK) forMonth IssueDate DueDate
The thing is that I want to be able to show the details In a SINGLE Datagrid Such that the students are divided - within the datagrid- on the basis of their respective grades. as in the diagram below---------------------------------------------------- playgroup ---------------------------------------------------- Name ForMonth Issued Date Due Date xyxy ---------------------------------------------------- Nursery ---------------------------------------------------- Name ForMonth Issued Date Due Date yyxy
I'm using ASP.NET, any ideas or code snippets would be greatly appreciated.:-D