VB.NET - Student Information System Project In VB.Net And MySQL Database [With Source Code] Part 33

Student Mangement System Project Using Visual Basic.Net And MySQL PART 33

Programming Projects:

before starting this serie you must :
- download and install visual studio
- have some knowledge in database
- downoad and install XAMPP or WAMPP server(we will use XAMPP)

- design and create a login form so the users can enter a password and a username , if the username or password are incorrect show an error message, else show a main form
- the user can show and hide password characters using a checkbox control.
- in the main form the user will see a menu and he can choose what to do next.

The Student Part
- in the manage student the user can add a new student,update student,remove student,
- a datagridview populated witth student records,
- if the user select a row from datagridview the selected student data will be displayed into textboxes and gender in radiobutton
(radiobutton to manage the student gender male or female)
- a label with the total students in the database
- a from to show the total students and percentage of male and female

The Course Part
- in the manage courses the user can add a new course,update course,remove course,
- a listbox populated witth courses names,
- if the user select an item from listbox the selected course data will be displayed into data fields
- a label with the total courses in the database
- a navigation buttons to go to the first, next, previous, last.

The Score Part
- in scores you can add a score to a student for a course,
- remove a student score for a course,
(you can not edit a student score to do that you have to delete it and reenter a correct data)
- a datagridview to show the scores and the students records
- show average score by course.

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

subscribe for more tutorials

VB.Net - How To Insert Update Delete Search Display Images From SQL SERVER 2014 [With Code] Part 1

Datagridview Header In Visual Basic.Net

Get Mouse Coordinates

VB.NET And MySQL Database Tutorials:

Connect MySQL Database To Visual Basic .Net:

Populate Datagridview:

Populate ComboBox:

Populate ListBox:

Visual Basic.Net Show Date MySQL Database:

Display Data From MySQL Depending On Combobox Value:

Insert Data:

Update Data:

Search Data:

Delete Data:

Insert Update Delete Search In MySQL Database:

Search Data In MySQL Between 2 Date:

Insert Image:

ExecuteScalar (COUNT, MAX, MIN, AVG):

Retrieve Image:

Update Image:

Insert All DataGridView Data:

Add Item To MenuStrip From MySQL:

Create Menu from MySQL Database Using Visual Basic .Net:

Using Stored PROCEDURE:

Share This Video: