auto email alert, windows service application with c# and sql database

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

, +

how to send an auto email alert, windows service application with c# in which email ids are taken from database with the help of SQL query....Plz help me out..

Thank YOu!!1

Posted 1-Feb-13 0:01am

Bhaskar Dhone

Add a Solution

Comments

Kishor Deshpande 1-Feb-13 6:05am

You want to send mail on specific events right?

Bhaskar Dhone 1-Feb-13 6:07am

yeah..

Bhaskar Dhone 1-Feb-13 6:15am

Thanks kishor...looking at link i guess it will help..but on more how to get email ids to which i want to send email form SQL database with the help of query and send them one by one automatically...

Kishor Deshpande 1-Feb-13 6:13am

Link 1 updated with simple Example from other site, please refer it.

Bhaskar Dhone 1-Feb-13 6:19am

ok..

Kishor Deshpande 1-Feb-13 6:20am

So if you want to send mail to all the people that are there in your database table,

you can code like this,
1) Define a method called GetAllUsers() returns List<Users>.
2) In this GetAllUsers() method, fetch the users from database using DataReader.
3) then for each user in listOfUsers, call Utilities.SendMail(user.Email,urEmailId, Subject, Message);

Bhaskar Dhone 1-Feb-13 6:35am

hey thanks.. and if i want it to send it on every friday as an alert...automatically without clicking anything with the updated data in database...hey i am fresher to new to these all...

Kishor Deshpande 1-Feb-13 6:40am

Hmm I'll answer this query after 2 hours, I'll be travelling for next 2 hours, could you please upvote my solution 1 and Accept it as answer?
Thanks.
Dnt worry I'll surely help you :)

Bhaskar Dhone 1-Feb-13 6:44am

yeah sure

Kishor Deshpande 1-Feb-13 8:57am

Sending email at particular date and time, Please refer links
http://code.msdn.microsoft.com/CSEmailScheduler-21564366
http://www.codeproject.com/Articles/69698/Set-the-Time-for-E-Mail-Sending-from-your-NET-Appl

Kishor Deshpande 1-Feb-13 9:45am

I've shared code of sending mail at link:
http://www.codeproject.com/Answers/538405/howplustoplusgetplusridplusofplusthepluserrorplusi#answer3
Hope it'll be useful for you :)

Bhaskar Dhone 2-Feb-13 0:01am

hey thanks kisohr... i guess we can send bulk sms in two way...one by one by putting it in foreach loop and other is Async way... will you plz tell me how to send it in Async way..i mean to all at the same time...

1 solution

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)

Kishor Deshpande · Accepted Answer · 2013-02-01T00:09:00

Solution 1

Please refer links:
Link1
Link2
I would suggest you to use this code and create a custom DLL called Utilities define a method SendMail().
Call the SendMail(to, from, subject,message) whenever you wish to send email to user.
If you have any question, please ask.

Thanks.

Posted 1-Feb-13 0:09am

Kishor Deshpande

Updated 1-Feb-13 0:12am

v3