I want to develop an Online Reminder service in ASP.NET 2.0 (C#) and SQL2005. But I am not getting the concept of reminder service. What I know is using an online reminder service I can schedule a reminder for future dates, which is sent to me (who schedule reminder) via email or SMS on that date. But in asp.net how to do this, caz anyone can schedule a reminder for any date, how we'll know that when to send that mail to the person. We have to put some loop or what.
So please guide me, what is the concept of an online reminder service and how I can easily develop this application using ASP.NET and SQL
Edited
I am on Shared hosting server, so that solution must be able to work on shared hosting.
Or
Please tell me if anyone knows about any FREE and open-source reminder service CMS which I can download and study it.
Yes, the key thing you need is a scheduler of some kind - usually you would use one of:
Any one of those could be set up to call a page on your site that would kick off this process.
As you are in a shared environment, you're not likely to have access to any of those, and so would need to have some other process in place.
What you could do is have remote (to the server) schedualer calling a page on your website that performs the lookup and sends the emails - this could either be something running on your dev/office environment (with all the attendant dangers of power/network failures, etc), or you could look at getting a "site monitoring" service that will ping a page on your server at regular intervals to check to see if it's up and running.
The page it hits would then:
We basically have a SQL Job that calls a page like this on our webserver to send out daily alerts, and it usually works quite well.
There's no reason why the page couldn't be called by a remote server to start this process.
Various options are available for this sort of thing:
Are just a couple, I'm sure that there are plenty more.