1,105,254 Community Members

i am making a Student Grading Sytem in Vb.net

Member Avatar
pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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..

Member Avatar
Reverend Jim
Noli mentula
5,394 posts since Aug 2010
Reputation Points: 746 [?]
Q&As Helped to Solve: 643 [?]
Skill Endorsements: 51 [?]
Moderator
Featured
 
0
 

You'll have to provide more information and a clearer description of what you are doing.

Member Avatar
tinstaafl
Postaholic
2,009 posts since Jun 2010
Reputation Points: 559 [?]
Q&As Helped to Solve: 400 [?]
Skill Endorsements: 35 [?]
 
0
 

Just a thought if the grade calculations were done in the database then it would just be a matter of pulling the relevant fields and poutting them in a report.

Member Avatar
mukiibi
Newbie Poster
3 posts since Nov 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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'.

Member Avatar
pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

i have a Marks_Tablein which
Gr_No (int)
Name (varchar)
Class (int)
Division (varchar)
Semester(varchar)
Exam (varchar)
Subject (varchar)
Maximum_Marks (int)
Minimum_Marks (int)
Obtained_Marks (int)
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

Member Avatar
john.knapp
Posting Whiz in Training
221 posts since Oct 2012
Reputation Points: 25 [?]
Q&As Helped to Solve: 22 [?]
Skill Endorsements: 4 [?]
 
0
 

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).

Member Avatar
Dili1234
Junior Poster
169 posts since Aug 2012
Reputation Points: -2 [?]
Q&As Helped to Solve: 7 [?]
Skill Endorsements: 3 [?]
 
0
 

If you have marks with you can use If else condition

 Dim marks As Integer = 51
        Dim grade As String


        If marks > 50 Then
            grade = "A"
        Else
            grade = "B"
        End If
Member Avatar
pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
Dili1234
Junior Poster
169 posts since Aug 2012
Reputation Points: -2 [?]
Q&As Helped to Solve: 7 [?]
Skill Endorsements: 3 [?]
 
1
 
 myConnection = New SqlConnection(connectionstring)
        myConnection.Open()
dim Marks as Integer
        myCommand = New SqlCommand(" Select columnname FROM tablename Where P_Id='" & ComboBox2.Text & "'", myConnection)
        Dim dr As SqlDataReader = myCommand.ExecuteReader
        While dr.Read()

        marks = Val(dr(0))

            'currentbalance = Double.Parse(dr(2).ToString)

        End While
        dr.Close()
        myConnection.Close()
Member Avatar
pratik65
Light Poster
31 posts since Sep 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
Dili1234
Junior Poster
169 posts since Aug 2012
Reputation Points: -2 [?]
Q&As Helped to Solve: 7 [?]
Skill Endorsements: 3 [?]
 
0
 

Can you put a picture of how your interface look like

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: