Looking for open source code/utility for maintain calendar in SQL Server DB

Question

I am looking for some (preferable vb.net) code to use in an asp.net application that will allow me/my users to setup calendars (that I store in SQL server db).

I am looking for something that will make it easy to schedule recurring appts (i.e. every monday, every other week on thursday at 9AM, every month,1st and 3rd tuesday, every year etc) with as many possible scenarios as possible.

I can automate most of the easy ones via a few screens, but inevitably my users come up with scenarios that require me to code and execute some custom scripts in SQL to make the entries, and I'd really like to offload this to the users.

Anyone know of any good starting points for this type of routine?

Answer 1

You can use the iCal spec to store this kind of data. There are .NET implementations of the spec and you can easily save the data to a file or database. Here's an article on using the DDay.iCal library.

I'm not aware of any open source schedulers but if you're interested in a 3rd party tool that uses the iCal spec Telerik makes a great scheduler.