I want to develop an application using ASP.NET technologies, VS 2010 and MS SQL server 2005. The application should have 3 users; admin,teacher, parent and student
1. The application must have a log in page that directs users to their respective pages
2. The app is used to generate student progress report based on 7 subjects.the system should capture student exam mark for each subject, grade and teacher's comments.
3.The admin manages users and the app records
4. Teacher insert, edit, delete student records
5. Student and parent view student reports
I have created a db with studentid, class,name, school, maths,eng, science,setswana,social studies, agriculure and teachers comments as fields. the student number is the primary key.
i have developed the asp page with labels and textboxes and buttons to be used for inserting and retrieving records from db.
Can anyone help or provide some suggestions for providing the functionality for inserting, selecting, updating and deleting student records using c# and web forms. i am newbie to programming . thank you.