Insert events from a database to a custom-made calendar
===

I made a custom calendar in C# because the ASP.NET's Calendar control wasn't suitable for my needs. My calendar is a dynamically created table and the cells represent days. I loop as many cells as there are days in a certain month. I can access a cell using the current year, month and day of the calendar.

Now I need to add event data from a database to the cells representing certain dates but I don't know how to do that. A single cell (day) should have as many labels (containing an event name) as there are events for that day.

The database is a table named "event". The structure of the table is the following:

    EventID, int;  
    EventName, varchar;  
    EventStart, varchar;  
    EventEnd, varchar.
