.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

How to remind birthdate

Posted By: Suresh     Posted Date: February 01, 2009    Points:2   Category :ASP.Net
hello friends
I want to remind the birthday date to user, how the orkut remind to us. like wise. can anyone please guide me through sample code. im using asp.net code behind c#

Responses
Author: Rahul             
Posted Date: February 02, 2009     Points: 5   

The best way to do from SQL Server Jobs. Create one jobs which runs every day say 12:00 AM in the morning that will check whose birth day is falling near 7 days using Sql Query.

Now you got the say 100 User whose Birth day is falling in next 7 days. Here you can use either of the following

Step 1 - Save the data to another table(Say ReminderTable) with one status flag 1 for sent mail
Step 2 - You can use SQL Server to send mail (Better choice) or you can create one window service to get data from the ReminderTable and send reminder mail.

Note you can also use some logic that everyday you have to send mail or not.

Code for sending mail you can search in this site itself.

Hope this Helps

Author: AMBROSIA             
Posted Date: August 19, 2012     Points: 20   

Dear Sir,
Please send me code for reminder mail with code and with example.



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend