I would like to create a list of appointments in a calendar for a particular day somewhat similar to what is displayed in MS Outlook using ASP.NET.
1. The appointment times are to be highlighted or shaded.
2. The Title and Notes of the related to a particular appointment time range are to be written once on the first row.
Here is an example from the following Website:
http://ftp-us-at.componentsource.com/res/pub/img/products/full/513079.gifHere is my database query and its output:
SELECT AppID,AppointmentDate,Star
tTime,Star
tTimeValue
= dbo.Fnc_Convert_TimeID_To_
Time(Start
Time), EndTime,EndTimeValue= dbo.Fnc_Convert_TimeID_To_
Time(EndTi
me),appSub
ject FROM Appointments
WHERE AppointmentDate = '08/24/2006'
AppID AppointmentDate StartTime StartTimeValue EndTime EndTimeValue appSubject
----------- --------------------- ----------- -------------- ----------- ------------ ---------------------
1 2006-08-24 00:00:00 8 3:30 AM 10 4:30 AM Meeting with Paul
2 2006-08-24 00:00:00 10 4:30 AM 14 6:30 AM Contract Meeting
3 2006-08-24 00:00:00 16 7:30 AM 18 8:30 AM Annual Sales Meeting
4 2006-08-24 00:00:00 20 9:30 AM 24 11:30 AM Annual Staff Meeting
How do I go about writing the ASP.NET script using VB to render the appointments similar to what is shown in the website below?
http://ftp-us-at.componentsource.com/res/pub/img/products/full/513079.gifI need your assistance.
Thank you,
DeMyu
Start Free Trial