Display data from MYSQL database in a calendar [VB.NET]

See more:

VB

MySQL

calendar

Good Morning.

I am developing a program in VB.Net and Its called Scheduling System, I am almost done developing it. Saving Information,Updating them and Giving Schedules to each Employee using the System but Today my Prof. ask me that he wants to see Persons with Schedule`s in a Calendar Design like this.

Sample Image

Based on the Image above here is the controls inside my form.

Calendar Control 12.0 (AxCalendar1)
    Label

this is the best way I can do to Show to you what Output I want. The Person 1 is also related in my MYSQL Database like this.

Database

all of the Image above is only an Example of what Output I want. Do i have something to do with the codings like:

select ElecAssigned from MyTable where ScheduledDate = '" & AxCalendar1.value(or Each Date of Calendar?) group by ScheduledDate;

is this the way to do it? As of now here`s what I have.

My Question is how can I display Data from my Database based on Date in Calendar? Lets say I will input data more and there `ScheduledDate` are Diff. How can I display the Data in Diff. Dates?

I hope all of you get my point.

General Question: How can I Display Data from MYSQL Database in Calendar Control by Date?

Please help me.

What I have tried:

I tried searching but I did not find possible solution to my problem