How To Display Events On A Grid

Question

0.00/5 (No votes)

See more:

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!

Posted 9-May-10 23:46pm

phil2415

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Brij · Answer 1 · 2010-05-10T00:04:00

Solution 1

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..

Posted 10-May-10 0:04am

Brij

Comments

phil2415 13-May-10 9:05am

Thanks for taking the time, Brij. It sounds like what you needed to build had far more functionality ("very similar to Outlook") than I need. As I said, I just need to display the information, nothing more. I'm not exactly sure what you mean by generating the week view dynamically.

Anyone else got any ideas?