Reminder

Question

User2137146631 posted

I want to do, I've added a database of important dates to the days when it comes to the screen to print warnings .

 

Answer 1

User-42918493 posted

http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx

Answer 2

User-29804325 posted

Hi,

Besides the SQL Server Job Schedular.

I think if you want to use a time reminder in web site or some pages,

You can use javascript or ajax to achieve this.

http://ajax.net-tutorials.com/controls/timer-control/

http://css.dzone.com/news/how-javascript-timers-work

Another method is use windows service

http://www.beansoftware.com/ASP.NET-Tutorials/Task-Scheduler-Windows-Service.aspx

http://www.c-sharpcorner.com/uploadfile/mahesh/window_service11262005045007am/window_service.aspx

http://msdn.microsoft.com/en-us/magazine/cc163821.aspx

Hopes can help you.

Answer 3

User-794331672 posted

Hi

For displaying message on screen for particular dates, you have to write a code on page load or use ajax update panel which async call page and compare dates from database.

Based on values of current date and database dates comparision , you can show message is current date = database date.

Hope i correctly understood your problem

Answer 4

User-1802908944 posted

you can add SQL server Scheduler Job

http://msdn.microsoft.com/en-us/library/ms191439.aspx