how to send emails dynamically based on expiry Date in asp.net

Question

0.00/5 (No votes)

See more:

hi guys ,
how to send emails dynamically based on expiry Date in asp.net.. and based on validity before one week need to send emails every day automatically . .
please help . ..

Posted 12-Jul-14 0:34am

u mani

Add a Solution

Comments

[no name] 12-Jul-14 6:37am

Help with what? Have you done any research at all? Written any code?

u mani 12-Jul-14 6:42am

no i don't have any idea . . i have one column in database with name validity based on this need to send automatic emails please give me the code . . .

[no name] 12-Jul-14 6:47am

Uhm.... no. We don't write code to order. You need to do some research and write some code yourself.

u mani 12-Jul-14 6:50am

okay can u give some idea about that ,like what kind of technique i need to use

[no name] 12-Jul-14 7:08am

Some idea about what? Doing some research? Writing some code? Why ASP is a bad idea? How to query a database? Start with http://www.google.com/search?q=ASP.NET+send+email and go from there.

u mani 12-Jul-14 7:17am

thank u

MuhammadUSman1 12-Jul-14 7:01am

Dear U mani, create window service,job in sql server. and send email according to your requirements.

u mani 12-Jul-14 7:09am

Dear MuhammadUSman, i dont have that much idea about that creating job in sqlserver ,can u gine me a sample code please . .

MuhammadUSman1 13-Jul-14 23:47pm

Please check i have post an answer.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2014-07-12T07:03:00

Read my past answer - How to send Automatic Messages from Asp.net C#?[^].

Quote:
For sending mails, you can create Console Application and add that to the Windows Task Scheduler.
You can select the Date and Time when to start and also set the repetition frequency.

It would automatically trigger, when the time interval is reached and repeat itself.

MuhammadUSman1 · Answer 2 · 2014-07-13T17:46:00

Solution 2

For window service check following links

Create Windows Service in Visual Studio [C#]

Creating a C# Service Step-by-Step

For Sql job.

Create a Job

Create and Schedule a Job in SQL Server

creating job in sql server 2008

Posted 13-Jul-14 17:46pm

MuhammadUSman1