Multi month :: Select, save and restore multi selections

2 posts, 0 answers
  1. Erik Paquet
    Erik Paquet avatar
    35 posts
    Member since:
    Dec 2006

    Posted 19 Jan 2010 Link to this post

    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



  2. Radoslav
    Admin
    Radoslav avatar
    1566 posts

    Posted 22 Jan 2010 Link to this post

    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.
Back to Top