Students Information Management System Source Code Using C# And MySQL Database
in this c# project demo you will see what you can do with this students information management system project build with csharp and a mysql database.
goals of this project:
- give students / curious persons an example so they can learn from.
- helping people create their first project.
- sharing knowledge with others.
tools:
- c# programming language.
- visual studio express 2013.
- mysql database
- canva.com for images
- flatuicolorpicker.com for colors
- text file ( to export data )
- text file ( to export data )
Watch This Full Demo
1 - Login Form
the login form allow the users to login into the application main form
if the user enter a wrong username or password a message will show up
and when the user enter 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.
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.
3 - Student Section
on the student section you can add, edit, remove, and more.
Students |
-> Add 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 in the database, when you double click on a datagridview row -> the selected will be displayed on a new form to edit / remove student,
and you can click on the refresh button to display the edited data.
in this form you can:
- search student by id.
- remove student.
- edit student data.
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:
- search student by id.
- remove student.
- edit student data.
-> Students Statics Form
this form contain the total students in the database, male students percentage, female students percentage.
statics form |
total students - mouse enter |
male students percentage - mouse enter |
female students percentage - mouse enter |
-> Manage Students Form
on this form you can do / see :
- get a list of all students in the database to a datagridview.
- see the total of students depending on the datagridview.
- search students by value and display them on the datagridview.
- get selected from datagridview to the data fields
- edit student information.
- remove selected student.
- add a new student.
- browse image from your computer to the picturebox.
- save the image from picturebox to your computer.
- clear / reset all fields.
-> Print Students Form
this form allow you to export students data from datagridview to a text file.
you can select students to display by birthdate or gender or both.
4 - Course Section
Courses |
-> Add Course Form
this form allow you to insert a new course with data verification:
- course name is not empty.
- course name not already exists.
- number of hours +10 H ( we did that from NumericUpDown control -> properties -> set minimum to 10 ).
- course name is not empty.
- course name not 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 .
- listbox populated with all courses.
- label with the total courses number.
- add a new course.
- edit the selected course.
- remove the selected course.
- navigate between courses.
- 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.
Delivery: Instant Source Code Download.
- C# Inventory System Source Code
- C# Hotel Management System Source Code
-> 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?:- listbox populated with all courses.
- label with the total courses number.
- add a new course.
- edit the selected course.
- remove the selected course.
- navigate between courses.
-> Print Courses Form
this form allow you to export courses data from datagridview to text file.4 - Score Section
Score |
-> Add Score Form
in this form you can set a score to a specific student on a specific course.-> Remove Score Form
in this form you can delete the selected score using 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.
show scores |
show students |
-> Print Scores Form
this form allow you to export scores ( by student or course ) data from datagridview to text file.all scores |
scores of the selected student |
scores for the selected course |
printed scores |
if you want the source code click on the download button below
Delivery: Instant Source Code Download.
- C# Inventory System Source Code
- C# Hotel Management System Source Code
10 comments
commentshi it will nice if u will also do Students Information Management System Source Code Using C# And SQL server Database , do u have such available thank u
Replyplease i dont see the source code, can you help me get it
Replyclick on the red button at the bottom of this post
ReplySIR may i have purchased may i have a copy of the tables on database please
Replyhi, you can find all tables script in the folder "database script"
ReplyHey guys how can i will work this job? I must download mysql?
ReplyWere do i find mysql.data.dll? Gott the MySQL App.
Replycaxac86412@noduha.com
ReplyCan u give it for free or ill pay back later
Replyпидорас
Reply