Click here to Skip to main content
12,895,911 members (46,994 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB VB.NET
i am making a Student Grading System in which will store student and teacher information into database, as well as it will store student marks of particular semester and exam. i have done with my storing information part and designing part and now i am doing the grade calculation but i am not getting the logic of how should retrieve all the Subjects and Their marks and on a form of a student and on that base i want to calculate its result i.e o Grade. please reply as soon as possible my project submission date is day after tomorrow..
Posted 18-Nov-12 9:03am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You would get all the marks for that student, and you'd need to know the maximum possible marks. Dividing these gets you a percentage which is generally how a grade is calculated.

If your work is due in 2 days, it's a bit late for you to be trying to understand the requirements. We're happy to help, but we don't help faster based on your demands, we're not being paid, so please don't ask us to reply 'as soon as possible', we will, by definition, reply 'when we feel like it'.
Pratik65 18-Nov-12 15:10pm
sorry my mistake...
i am want to say is that i have a marks table in that i save save the students rollno,semester,exam,maximum_marks,minimum_marks,obtained i want to retrieve all subject of that student and its marks for particular semester and exam and on that basis i want to calculate the there any guidance i can get with this ?
Christian Graus 18-Nov-12 15:14pm
yes. You have the data, so write the SQL. You know the semester, so ou can filter on it. You know the exam, so you can filter on it. Where is your issue ? If you want us to write the code because you can't even START, then surely you can see that all I can give is vague advice without more info on the DB structure ( not that I am saying I'd do your assignment for you ). You have the data you need, why don't you see how to write the SQL to filter on it ? Do you not know how to write SQL at all ? You can use group by to get a maximum, minimum, average or aggregate mark for each exam, in one SQL call, if you need it.
Pratik65 18-Nov-12 15:21pm
yes i have filtered the semester and exams but i an not getting the logic of ,how i should retrieve all the subjects and their Obtained_marks From the marks table of particular student from the semester and exam selected into a form ....dont do my homework but can u please help me explain in a easy way please..
Christian Graus 18-Nov-12 15:40pm
If you want all the marks a student got, filter on the student and the subject, but not the exam. Change what you filter out, and the rest will give a return of all results.
ridoy 18-Nov-12 15:44pm
Pratik65 19-Nov-12 8:25am
but without filtering the exams ,we will not get of which exams this marks is.
So i have to filter the subject ,exams and marks in that subject in that exam
can u give me some link or idea from which i can solve this part

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170424.1 | Last Updated 18 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100