Student Management System Project using C# and MySQL

Get the source code: https://1bestcsharp.blogspot.com/2018/07/csharp-student-information-system-source-code.html

Learn how to create this project: http://bit.ly/StudentSystemTutorials

—————— Discover my C# projects! ——————–

Inventory Management System – http://bit.ly/Csharp_Inventory

Student Information System – https://bit.ly/Csharp_Students

Contact management system – https://bit.ly/2VEZWtt

Hotel Management System – http://bit.ly/Csharp_Hotel

Real Estate Management System – https://bit.ly/Csharp_RealEstate

Library Management System – https://bit.ly/Csharp_Library

All my programming projects here – http://bit.ly/2HrU8hK

My source code is stored here – http://bit.ly/2OsC0TU

—————– C# PRODUCTS —————–

Get the C# Projects Bundle – http://bit.ly/CsharpProjectsBundle

Learn C# and more – http://bit.ly/CoursesList

—————————–

Programming projects:
http://1bestcsharp.blogspot.com/p/programming-projects.html

subscribe: http://goo.gl/nRjPKk

In this C# project demo, we will see how to create a basic information management system for our students using C# with Visual Studio and MySQL database.

before starting this series you must:
– learn core C#.
– download and install Visual Studio.
– have some knowledge of databases.
– download and install XAMPP or WAMPP server (I use XAMPP).

tools:
– C# programming language.
– visual studio express 2013.
– mysql database
– canva.com for images
– flatuicolorpicker.com for colors
– text file (to export data)

*** The main form ***

the main form contains 3 tabs, one for students, the second for courses and the last for grades.

***Student section***
In the student section you can add, edit, delete and much more.

– Add a student form:
this form allows you to insert a new student with data verification before insertion

– Student list form:
this form contains a datagrid populated with all students in the database, when you double click on a row in the datagrid – the selection will be displayed on a new form to edit/delete the student,
and you can click the refresh button to view the changed data.

– Update the student deletion form:
You can access this form by clicking /"Edit/Delete/" in the top menu, or by double-clicking a student in the student list form.

under this form you can:
– search for a student by identifier.
– delete the student.
– modify student data.

– Student statistics form:
This form contains the total number of students in the database, the percentage of male students, and the percentage of female students.

– Manage the student form:
* Get a list of all students from the database in a datagridview.
* view total students based on datagridview.
* search students by value and display them on the datagridview.
* be selected from datagridview to data fields
* edit student information.
* Delete selected student.
* add a new student.
* Browse the image from your computer to the Picturebox.
* Save the image from Picturebox to your computer.
* clear/reset all fields.

– Print the student form:
This form allows you to export student data from datagridview to a text file.
you can select students by date of birth, gender, or both.

*** Courses Section ***

– Add a course form:
this form allows you to insert a new course with data verification:
*course name is not empty.
* The course name does not already exist.
* number of hours 10 H (we did this from the NumericUpDown control – properties – set to at least 10).

– Edit the course form:
in this form you can modify the selected course from the drop-down list.

– Delete the course form:
This form allows you to delete a course with the given identifier.

– Manage the course form:
what does this form contain? and what can you do about it? :
* listbox filled with all courses.
*label with the total number of courses.
* add a new course.
* modify the selected course.
* delete the selected course.
* navigate between courses.

– Print the course form:
This form allows you to export course data from datagridview to a text file.

*** Score section ***

– Add a score form:
in this form you can assign a score to a specific student in a specific course.

– Delete the score form:
in this form you can delete the selected partition using datagridview.

– Score management form:
what does this form contain? and what can you do about it? :
* a data grid view to display students or scores using buttons.
* add a new score for the student selected from datagridview on the course selected from the combobox.
* Delete selected score using student id and course id.
* delete the selected course.
* display the average grade per course on a new form.

– Print the score form:
This form allows you to export score data (by student or by course) from datagridview to a text file.

NOTE: If we delete a student or course, all scores associated with them will also be deleted.

Share this video:
https://youtu.be/MmmTReqXVlk

#Csharp #Student_Information_System #Csharp_Project_Source_Code

Please take the opportunity to connect and share this video with your friends and family if you find it useful.