I have three table in sql server database
Tables are:-
1. StudentDtl(RollNo,Name,CourseCode,Semesester)
2. CourseMarkMaster(CourseCode,ToatalMarks,PassMarks)
3.StudentMarkDtl(RollNo,CourseCode, ObtainMarks,GraceMarks)
Maintain Grace Markss
create trigger for GraceMark
1. Grace-100 obtatinMarks is between 36-39
then grace is 4,3,2,1
2. RollNo should be mapped with table 1 use Store Procedure.
ObtainMarks not negative and not greater then TotalMarks
CoureseCode
CouresCode should be Mapped with table 2
| RollNo | TextBox |
| Course | DropDownlist |
| ObtainMarks | textbox |
| btnsubmit |
Sanwar RanwaPosted Sep 13, 2018, 5:24 AM