c# - How to create recurring calendar events? -

i using asp mvc 3, jquery full calendar, ms sql sever 2008 , c#.

i wondering if knows how make recurring events?

i unsure how make them.

for instance in google calendar can make appointment repeat yearly forever. doubt generate appointment x times in database.

i wondering how have 1 row in db , somehow know call when needed.

also google calendar , outlook have lots of repeating options repeat on 1st month, last month , etc.

is there libraries build have this? or got make scratch?

p.s

i on shared host solution has work limited rights.

generating possible repetitions of event (in theory) fill storage events never ever seen user (congrats on 999,999,999,999,999,999,999th birthday!).

it takes bit more work, solution store table (or tables) of repetition rules link calendar entries build calendar:

"for every day of week being shown, check events repeat on days" "for every week of month being shown, check events repeat in weeks" "for every month in year", etc...

how many of these checks have depends on how many types (and duration) of repetitions you'd want.

as supressing events, that's yet table listing points @ dates/times have supressed. "if showing mondays, show events repeat on months, except ones listed in supression table"

comment followup:

well, you'd have standard calendar entry table, store core information. date/time, etc... @ least 2 other tables store repeat information. 1 stores repetition rules. "every monday", "first day of month", "every year", etc..., , third table links between calendar entries , the rules

so:

 calendar entries table  <--->  link table  <--->  repeat rules table 

querying matter of building things date you're considering, appropriate rules come out , give ids of calendar entries display. ugly if fancy query dynamically links appropriate rules based on date you've passed in.