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