I am facing a difficulty in representing the student score card data in a dynamic matrix format. The rows and columns both are dynamic. And each column in turn has 2 cells having different values. To explain more in details let us assume a Student Subject matrix where Each Subject is a row - The number of rows decided by the user selection. Each student is a column - The number of columns is again based on user selection.
Each student in turn has two semesters as fixed sub columns ( cells). Values for semesters is the Marks scored by the Student.
What is the best approach I can take to build such a matrix representation in asp.net? Please suggest different approaches and which is best in terms of performance.