Multi month :: Select, save and restore multi selections

[Erik Paquet]

Hi,

I am tring to create a year calendar (multi month) to select, save and restore in a DB multiple sections (periods) and I do not know where to start.  My goal is to setup a banner system where the same banner can be showed for multiple days at different period in a year.

For example: december 2,3,4,5,6 ; january 9,10,11,12,13; etc.

My DB is not structured so I am free to set it up to support the calendar.  The selected dates could be saved in 1 field (comma separated) or in many records (one for each period - start to end).

1. Is it possible to do it with the calendar control?
2. Do you have clue, sample, demo, hit to help me to start it correctly?

Thank you

Erik

[Radoslav]

Hi Erik,

You could make two tables in your database. One for dates and one for images. So your tables could be:

TableBanerImages
Columns:
ImageId -> PrimaryKey, autoincrement
ImagePath -> varchar(250)

TableDates
Columns:
DateId -> PrimaryKey, autoincrement
Date - > datetime
ImageId -> ForeignKey to ImageId from the first table

In the end you will have two tables with one- to-many relationship. On one image corresponds many dates on which this image will be shown.

Then with RadCalendar you could show multiple months with customized date's templates on which you could show the images from database.
You could find the online demo of RadCalendar with multi-month view here:

http://demos.telerik.com/aspnet-ajax/calendar/examples/functionality/multimonthview/defaultcs.aspx

And online demo of Calendar with special days and templates you could find here:

http://demos.telerik.com/aspnet-ajax/calendar/examples/functionality/specialdays/defaultcs.aspx

You could achieve the desired functionality by combining the multi-month view calendar with calendar with special days and templates.

I hope this helps.

All the best,
Radoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.