i am making a Student Grading System in Vb.net 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..
i think that by the time you insert the marks into the database, the computation of the grades and everything should have already been done on your interface and about retrieving the results, i believe every student should have an id so you have to enter different marks for the different students using that same id so that when you are to retrieve the marks, you have got to use a select*from db where id='somevalue'.
i have a Marks_Tablein which
are the columns of my table in the database.
i wanted when user selects or (filter) a particular class ,Division,Exam,Gr_No from the form, it should retrieve all the Subjects and the obtained_marks he got in each subjects on to a form and on that Obtained_marks base i have to calculate the overall grades and give it to the user but i am not getting the logic for it ,how will i get that the exact output. i have tried the crystal report but i didnt got the correct output so now i want to retrieve it on form instead of report. please give some guidance on it
Maybe I'm not understanding your requirements, but if your Gr_No is already an int value; just add up all the int values and divide by the total number of values - that will give you the average value - then just display that value (and/or update your Obtained_Marks field).
i can put the if else condition but first i have to retrieve the students marks in each subject from the database and then put then i will put them in if else condition but i dont know how i should retrieve from database
myConnection = New SqlConnection(connectionstring)
dim Marks as Integer
myCommand = New SqlCommand(" Select columnname FROM tablename Where P_Id='" & ComboBox2.Text & "'", myConnection)
Dim dr As SqlDataReader = myCommand.ExecuteReader
marks = Val(dr(0))
'currentbalance = Double.Parse(dr(2).ToString)
ya i got but but this will retrieve only the marks of the subjects but i want to retrieve all the subject of the student and its marks on a textbox then i will calculate the grade upon the marks how should i retrieve all subject and their marks