Email Reminder

Posted by Krish_17nov under Regular Expressions on 3/27/2009 | Views : 3989 | Status : [Member] | Replies : 2
Hi all,
I am having a customer table having its name and date of joining. I want that the system automatically send a E-mail reminder
before a week of its membership expiration date, if the membership is for one year in that case the system will automatically send a mail
before a week to the client to rejoin the system.

I am using dot net 3.5 and sql server 2005.

please send me the response.

Thanks




Responses

Posted by: Raja on: 3/28/2009 [Member] Starter

Up
0
Down
You can write a SQL Server jobs that will keep running and checking the database table for the member ship status and as soon as it will find some member's expiry within a week, it will send an email.

OR

You can write a separate Windows Service application that will run in background and check for the same.

Thanks

Regards,
Raja, USA

Krish_17nov, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeks on: 3/31/2009 [Member] Bronze

Up
0
Down
You can complete this site using the Windows service functionality provided by the .Net.
Please follow the Given link for the Sample creating the Windows service
http://www.c-sharpcorner.com/Articles/ArticleListing.aspx?SectionID=1&SubSectionID=78

Krish_17nov, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response