Student Mangement 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------------------ Check out my C# Projects! --------------------
▶ Inventory Management System -
http://bit.ly/Csharp_Inventory▶ Students Information System -
https://bit.ly/Csharp_Students▶ Contacts 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 Store Here -
http://bit.ly/2OsC0TU----------------- C# PRODUCTS -----------------
▶ Get C# Projects Bundle -
http://bit.ly/CsharpProjectsBundle▶ Learn C# And More -
http://bit.ly/CoursesList-----------------------------
Programming Projects:
http://1bestcsharp.blogspot.com/p/programming-projects.htmlsubscribe:
http://goo.gl/nRjPKkIn this c# project demonstration we will see how to create a use our basic students informations management system using c# with visual studio and mysql database
before starting this serie you must:
- learn c# core.
- download and install visual studio.
- have some knowledge in database.
- downoad and install XAMPP or WAMPP server(i'm using 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 contain 3 tabs, one for the students, the second for the courses, and the last one for the scores.
*** Student Section ***
on the student section you can add, edit, remove, and more.
- 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.
- 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.
- Manage Students Form:
* 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 text file.
you can select students by birthdate or gender or both.
*** Course Section ***
- Add Course Form:
this form allow you to insert a new course with data verification:
* course name 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 .
- 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.
*** Score Section ***
- 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 to 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.
- Print Scores Form:
this form allow you to export scores ( by student or course ) data from datagridview to text file.
NOTE: if we delete a student or a course all scores associated with them will be also deleted
Share This Video:
https://youtu.be/MmmTReqXVlk#Csharp #Student_Information_System #Csharp_Project_Source_Code
About the Site 🌐
This site provides links to random videos hosted at YouTube, with the emphasis on random. 🎥
Origins of the Idea 🌱
The original idea for this site stemmed from the need to benchmark the popularity of a video against the general population of YouTube videos. 🧠
Challenges Faced 🤔
Obtaining a large sample of videos was crucial for accurate ranking, but YouTube lacks a direct method to gather random video IDs.
Even searching for random strings on YouTube doesn't yield truly random results, complicating the process further. 🔍
Creating Truly Random Links 🛠️
The YouTube API offers additional functions enabling the discovery of more random videos. Through inventive techniques and a touch of space-time manipulation, we've achieved a process yielding nearly 100% random links to YouTube videos.
About YouTube 📺
YouTube, an American video-sharing website based in San Bruno, California, offers a diverse range of user-generated and corporate media content. 🌟
Content and Users 🎵
Users can upload, view, rate, share, and comment on videos, with content spanning video clips, music videos, live streams, and more.
While most content is uploaded by individuals, media corporations like CBS and the BBC also contribute. Unregistered users can watch videos, while registered users enjoy additional privileges such as uploading unlimited videos and adding comments.
Monetization and Impact 🤑
YouTube and creators earn revenue through Google AdSense, with most videos free to view. Premium channels and subscription services like YouTube Music and YouTube Premium offer ad-free streaming.
As of February 2017, over 400 hours of content were uploaded to YouTube every minute, with the site ranking as the second-most popular globally. By May 2019, this figure exceeded 500 hours per minute. 📈
List of ours generators⚡
Random YouTube Videos Generator
Random Film and Animation Video Generator
Random Autos and Vehicles Video Generator
Random Music Video Generator
Random Pets and Animals Video Generator
Random Sports Video Generator
Random Travel and Events Video Generator
Random Gaming Video Generator
Random People and Blogs Video Generator
Random Comedy Video Generator
Random Entertainment Video Generator
Random News and Politics Video Generator
Random Howto and Style Video Generator
Random Education Video Generator
Random Science and Technology Video Generator
Random Nonprofits and Activism Video Generator
