I got to create a system that automatically sends out an email when the server date is equal to a date field in an sql server database. The project I am working has been built using asp but I can't find a solution using classic asp. I'm relatively new to asp.net and thought maybe using a .net web service to provide this functionality. Can anyone advise me of a way to do this asp or asp.net and whether I was on the right track with the web service idea?
Thanks in advance.Hi,
You don't require a webservice for this. Instead you can create a console application using c# or vb.net which will be an exe that will run daily at a specified time and check if the server date is equal to that in the database and then send out a mail, if it is equal.
Once you are done with the logic, you can put it in task scheduler (type tasks form command prompt) for the same to run daily.
Hope it helps.
0 comments:
Post a Comment