C# Students Information System Source Code

Students Information Management System Source Code Using C# And MySQL Database

Students Information Management System Source Code In C#

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 )

Watch This Full Demo



1 - Login Form

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

C# Students Information System Source Code - login form

if the user enter a wrong username or password a message will show up

C# Students Information System Source Code - login form error

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.



C# Students Information System Source Code - main form - students
Students

-> Add Student Form

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

C# Students Information System Source Code - add student


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


C# Students Information System Source Code - students list


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


C# Students Information System Source Code - edit, remove student





-> Students Statics Form


this form contain the total students in the database, male students percentage, female students  percentage.

C# Students Information System Source Code - statics
statics form

C# Students Information System Source Code - statics - total students
total students - mouse enter

C# Students Information System Source Code - statics - male students
male students percentage - mouse enter

C# Students Information System Source Code - statics - female students
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.

C# Students Information System Source Code - manage students

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



C# Students Information System Source Code - printed students list


4 - Course Section


C# Students Information System Source Code - main form - courses
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 ).


C# Students Information System Source Code - add course

-> Edit Course Form



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


C# Students Information System Source Code - edit course

-> Remove Course Form


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



C# Students Information System Source Code - delete course



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



C# Students Information System Source Code - manage courses




-> Print Courses Form

 this form allow you to export courses data from datagridview to text file.



C# Students Information System Source Code - print courses



C# Students Information System Source Code - printed courses list


4 - Score Section


C# Students Information System Source Code - main form - scores
Score

-> Add Score Form

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


C# Students Information System Source Code - add score

-> Remove Score Form

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


C# Students Information System Source Code - delete score



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

C# Students Information System Source Code - manage scores - show scores
show scores

C# Students Information System Source Code - manage scores - show students
show students

-> Print Scores Form

 this form allow you to export scores ( by student or course ) data from datagridview to text file.

C# Students Information System Source Code - print scores
all scores

C# Students Information System Source Code - print selected student scores
scores of the selected student

C# Students Information System Source Code - print selected course scores
scores for the selected course
printed scores


Share this

Related Posts

Previous
Next Post »

10 comments

comments
16 janvier 2019 à 04:45 delete

hi 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

Reply
avatar
7 avril 2019 à 14:50 delete

please i dont see the source code, can you help me get it

Reply
avatar
8 avril 2019 à 01:23 delete

click on the red button at the bottom of this post

Reply
avatar
Anonyme
19 novembre 2019 à 17:23 delete

SIR may i have purchased may i have a copy of the tables on database please

Reply
avatar
20 novembre 2019 à 02:01 delete

hi, you can find all tables script in the folder "database script"

Reply
avatar
23 octobre 2020 à 12:50 delete

Hey guys how can i will work this job? I must download mysql?

Reply
avatar
13 mars 2021 à 06:46 delete

Were do i find mysql.data.dll? Gott the MySQL App.

Reply
avatar
Anonyme
4 mai 2022 à 14:08 delete

Can u give it for free or ill pay back later

Reply
avatar