in Web application i have a table with 4 columns those are
1.College code2.1st year3.2nd year4.3rd yearagain in 1st,2nd,3rd years i have 3 columns in each column those are a) Admittedb) Registeredc) Conformed
The data it should come from sql database of combining of 2 or 3 tables
So now i want college code wise and year wise no.of admitted , registered ,conformed students
with paging option and at the same time i want to convert total data into excel format after getting results when click export to excel button
example like this
College code | 1st year | 2nd Year | 3rd year |
| Admitted | Registered | Conformed |
|
|
|
|
|
|
|
Export to excel