Tornado API Library - V12.30.08

z.dbEventCalendar Property

Stand alone calendar with event text and scheduling capabilities.

Product Version

[Visual Basic]
Public Property dbEventCalendar As String
public string dbEventCalendar {set;}

Property Value

Mydb.dbEventCalendar="Type=Normal or Event | Param=Value| Param=Value |....."

TypeNormal(Def) or Event.
WidthWidth of calendar in pixels
HeightHeight of calendar in pixels
MaxTextLengthWhen Calendar in event mode, maximum size of the event string in the day block. Def=64
PosterImages String list containing the name of the poster imaged you want to appear in the calendar. The separator is (;). For example "img1.gif;img2.gif;img3.gif".
CalendarDirDefault virtual directory for posterimages, event and schedule files. e.g. (def) calendardir=/Tornado/DB/Calendar/.

Note: For WS2003 and above (and not below), the Java Applets security is tightened and data file should be read only from directory at the same level as the application ann below. Threrfore, use calendardir = "./CalData/".

EventFileUrlURL of the event file. It can be a text file or a script to call. The file contains one line by event. Each line contains 3 fields
  • The month
  • The day
  • The label of the event
If the filename contains the character '#', this character is replaced by the year shown by the calendar.

Example: To make the calendar call a script myscript.aspx, with a parameter year equal to the year.

You must enter : eventfileurl=./myscript.aspx?year=#

You can also create an event file for each year. if you set the parameter eventfileurl with this value : eventfileurl=./file#.evt aspdbcalendar will try to open ./file2003.evt for the year 2003, ./file2004.evt for 2004, and so on.... If the character '#' is not present in the filename, the calendar will use the same event for each year.

See the note about event data files location in CalenderDir.

ScheduleFileUrl URL of the schedule file. It can be a text file or a script to call. If the filename contains the character '#', this character is replaced by the year shown by the calendar.

Example: To make the calendar call a script myscript.aspx, with a parameter year equal to the year You must enter : schedulefileurl=./myscript.aspx?year=#

When EventCalendar has to show the year 2003 planning, it will try to read the URL "./myscript.aspx?year=2003"

When aspdbcalendar has to show the year 2004 planning, it will try to read the URL "./myscript.aspx?year=2004"

If this character is not in the filename, aspdbcalendar will use the same planning file for all the years.

If this parameter is not set, aspdbcalendar will read a file called year.txt to take the schedule. (Example: 2003.txt for the year 2003).

Example: You have two workers John and Bill. To show their schedule just create the files (for the year 2003): john2003.txt and bill2003.txt and call with parameters:

schedulefileurl=./john#.txt to display the schedule of John

schedulefileurl=./bill#.txt to display the schedule of Bill

The file contains a line for each month. Each line is a string of '0' and '1', one character for one day. 0 for free day, 1 for full day.

See the note about Schedule datafiles location in CalenderDir.

ButtonColorColor of the arrow buttons.
TitleColorColor of the title bar. If not set, the Calendar use the color_comment parameter. In the original calendar, there is a line at the bottom of the calendar for displaying the event associated to the day. This line's color was given by the color_comment parameter.
BGcolorColor of the area not covered by calendar days.
LockoutDayColorDays which are locked out in schedule, cursor stays as arrow. Overrided by color_case when not set. Mouse clicks are rejected in lockout days.
FreeDayColorGeneral day color when the calendar is planning mode and not in a schedule mode ( just a simple calendar ). You don't need it if you use the calendar in the schedule mode. If color_empty or color_full are not set, the calendar uses color_case instead.Mouse click are accepted in "Free" days.
CommentColorComment color. The comment is the string at the bottom of the applet. Do no use this in Diary mode.
EmptydayColorColor for 'not occupied' days which cursor turns to hand. Overrided by color_case when not set.
FormNameForm where the field to update is placed
FieldNameName of the field to update
JSnameName of the javascript function to call. Don't forget the ().
DateFormatDate format to use in the field. String with
  • 'a' or 'y' for the year
  • 'm' for the month
  • 'd' for the day
  • Other characters are only copied
The default format is "m.d.y"
CommentLinesNumber of line(s) to keep for the comment rectangle at the bottom of the calendar. The default is 1
DayNamesFor Event mode only.

Enter in these parameters the name of the days in your language. Day1 is Sunday, day7 is Saturday


Example in French - Dimanche,Lundi,Mardi,,Mercredi,Jeudi,Vendredi,Samedi

MonthNamesFor Event mode only.

Enter in these parameters the name of the month in your language. Month1 is January, Month12 is December


Example in French - Janvier,Février,Mars,Avril,Mai,Juin,Juillet,Aout,Septembre,Octobre,Novembre,Décembre

Target Target where to show the URL associated to an event in a multi-frame environment.
CurrentDayColorColor of the current day
FirstWeekdayFirst week of the day. 0=Sunday,1=Monday...Default is 0
InitDayBy default, the first month displayed by the calendar is the current month with no day selected. dinit allows to specify the first month displayed and select a day.

The format is ddmmyyyy

Example : 15012003 for the 15th January 2003.
SelectedDayColorColor of the selected day
InitFldName>Name of the field where to choose the date initially shown. This field must be in the form specified by the parameter form.


While dbCalendar is used for popup date selection, an event calendar is one that is stand alone diary type calendar when the ASPdbCalendar method is used. It works like a diary with text in the day cell. Events and Schedules can also be used in conjunction with this stand alone control. A monthly poster option is also available. Javascript is also supported.

See Also

z Class | Tornado Namespace | dbCalendar | ASPdbCalendar