VB.Net Students Information System Source Code

Students Information Management System Source Code Using Visual Basic.Net And MySQL Database

Visual Basic.Net Students Management System

in this vb.net project you will see how to use this project and what you can do with this students information management system project build with visual basic.net and a mysql database.

→ watch how to build this project. 

goals of this project:
- give students / curious persons an example so they can learn from.
- give a full project serie to build it on your own.
helping people create their first project. 
sharing knowledge with others.


tools:
- vb.net programming language.
- visual studio ide.
- mysql database
- canva.com for images.
- flatuicolorpicker.com for colors.

Watch This Full Demo



1 - Login Form

the login form allow the users to login into the application main form


if the user enter wrong username or password ( or not entering any data ) a message will show up


and when you enter the correct username and password


when you click on the login button the main form will show up and the login form will close it self.
you can close the form by clicking the Cancel button.


2 - Main Form

the main form contain 3 tabs, one for the students, the second for the courses, and the last one for the scores.
i made the background image using canva.com.


3 - Student Section


on the student section you can add, edit, remove, and more.






-> Add a New Student Form

this form allow you to insert a new student with data verification before the insert



-> Students List Form


this form contain a datagridveiw populated with all the students data in the database, when you double click on a datagridview row -> the selected stident data will be displayed on a new form to edit or remove it,
and you can click on the refresh button to display the edited data.




-> Update Delete Student Form

you can access to this form by clicking on the "Edit / Remove" in the top menu, or by double clicking on a student in the students list form.
in this form you can remove student or edit student data but first you must enter the student ID.







-> Students Statics Form


this form contain the total students in the database, male students percentage, female students  percentage with a little animation when the mouse enter or leave the panel.


-> Manage Students Form

on this form you can do / see :
- get a list of all students ith their image from the database to a datagridview.
- see the total of students depending on the datagridview.
- search students by value and display the result on the datagridview.
- get the selected student from datagridview to the data fields
- edit the selected student information.
- remove the selected student.
- add a new student.
- browse image from your computer to the picturebox.
- clear / reset all fields.



4 - Course Section




-> Add Course Form


this form allow you to insert a new course with data verification:
- check if the course name is not empty.
- check if course name already exists.
- number of hours +10 H ( we did that from NumericUpDown control -> properties -> set minimum to 10 ).



-> Edit Course Form



in this form you can edit the selected course from the combobox .




-> Remove Course Form


this form allow you to delete a course with the given id .






-> Manage Courses Form

 what this form contain ? and what you can do on it?:
- a listbox populated with all courses.
- a label displaying the total courses number.
- add a new course.
- edit the selected course.
- remove the selected course.
- navigate between courses.






4 - Score Section



-> Add Score Form

in this form you can set a score to a specific student for a specific course.




-> Remove Score Form

in this form you can delete the selected score from datagridview.





-> Manage Scores Form

 what this form contain ? and what you can do on it?:
- a datagridview to show students or scores using two buttons.
- add a new score for the selected student from datagridview on the selected course from combobox.
- remove the selected score using student id and course id.
- remove the selected course.
- show the average score by course on a new form.

Manage Scores
show students in the datagridview

show scores in the datagridview

3 commentaires: