在日历中显示来自MYSQL数据库的数据[VB.NET] [英] Display data from MYSQL database in a calendar [VB.NET]

问题描述

早上好。



我正在VB.Net开发一个程序，它叫做调度系统，我差不多完成了它的开发。使用系统保存信息，更新它们并为每个员工提供时间表但是今天我的教授问我他想在日历设计中看到人员如此。



示例图片



基于上面的图片是我表格中的控件。

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是我能做的最好的方式向你展示我想要的输出。 Person 1在我的MYSQL数据库中也是这样的。



数据库



以上所有图片只是我想要的输出示例。我是否与以下编码有关：

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;

是这样做的吗？到目前为止，我所拥有的是什么。



我的问题是如何从我的数据库中显示数据在日历中的日期？让我说我会更多地输入数据，那里`ScheduledDate`是差异。如何在差异日期显示数据？



我希望所有你明白我的观点。



一般问题：如何按日期在日历控件中显示MYSQL数据库中的数据？



请帮帮我。



我尝试过：



我试过搜索，但我做了找不到我的问题的可能解决方案

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

推荐答案

您可以购买控件付款，或者您可以编写自定义控件。



查看此CodeProject文章以获得一个很好的示例 Calendar.NET [< a href =http://www.codeproject.com/Articles/378900/Calendar-NETtarget =_ blanktitle =New Window> ^ ]



- 这是一篇关于DataBinding的CP文章控制... 在自定义控件中实现复杂的数据绑定 [ ^ ]

There are paid for controls you could buy or you could write a custom control.

Have a look at this CodeProject article for a good example Calendar.NET [^]

- And here is a CP article on DataBinding that control ... Implementing complex data binding in custom controls[^]

这篇关于在日历中显示来自MYSQL数据库的数据[VB.NET]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！