如何在网格上显示事件 [英] How To Display Events On A Grid

问题描述

大家好，

我是长期阅读者，但是第一次海报，所以要保持温柔！

我需要在日历网格上显示数据库中的一些事件.简单来说，SQL数据库中的每个记录都有开始日期和时间，结束日期和时间，标题和房间号.我想显示一个网格，其中每列是一个房间，左下方是一个时间标尺"，以显示一天中的小时数.效果与在日视图中并排打开多个Outlook日历相同.

有第三方解决方案，但至关重要的是，我根本不需要与显示器进行任何交互.纯粹是为了显示当天在哪个房间中的约会.没有人需要能够操纵约会，将其用于日程安排或类似的事情.它只是一个静态显示，将根据数据库中的记录自动更新.

理想情况下，我想以ASP.NET页面的形式进行此操作，并且我可以创建一个以每列为一个房间的gridview，但是我不知道怎么做就是显示时间标尺和获得约会以使自己适应正确的时间.这确实超出了我以前做过的任何事情.

有人可以帮忙吗?有什么建议?我只真正了解ASP.NET和Visual Basic，并且正在使用Visual Studio2010.

谢谢！

Hi everyone,

I''m long-time reader but a first-time poster so be gentle!

I need to display some events from a database on a calendar grid. Simply, each record in the SQL database has a start date and time, an end date and time, a title and a room number. I want to show a grid, where each column is a room and down the left-hand side is a ''time ruler'', showing the hours of the day. The effect would be the same as having several Outlook calendars open side-by-side in day view.

There are third-party solutions out there but crucially I don''t need there to be any interaction at all with the display. It''s purely for displaying what appointments are in what rooms that day. Nobody needs to be able to manipulate the appointments, use it for scheduling, or anything like that. It''s very simply a static display, which will update automatically based on the records in the database.

Ideally I''d like to do this as an ASP.NET page, and I can get as far as creating a gridview with each column as a room, but what I don''t know how to do is show the time ruler and get the appointments to align themselves to the right times. This is really beyond anything I''ve done before.

Can anybody help with this? Any suggestions? I only really know ASP.NET and Visual Basic and I''m using Visual Studio 2010.

Thanks!

推荐答案

我已经开发了一种非常类似于Outlook的应用程序.早些时候我尝试使用Infragistics控件，但后来离开了它并创建了自己的控件.为此，我们动态生成了与Outlook相同的周视图等.我们从db中获取数据，并根据条件生成了整个HTML.

您也可以这样做..

I have developed this kinda application very similar to outlook. Earlier I was trying with infragistics controls but later left it and create our own.So for that we generated the week view etc dynamically same as outlook.We took the data from db and based on condition generated the whole HTML.

You can also go for that..

这篇关于如何在网格上显示事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！