Solved

How do I send email alerts to users through either a web site or SQL?

Posted on 2009-05-07
2
162 Views
Last Modified: 2012-05-06
I have build a C# web site using visual studio 2008. I am using an asp.net 3.5 listview control on my frontend to display data from my SQL Server 2005 backend database. I am using both linq and sql datasources throughout my web site. I have recently built a page within my web site containing a ReportViewer control bound to an objectdatasource to display reports to my users depending on filters they set through drop down list and textbox controls on the pages frontend. What I now need to do is some how send email alerts to my users when certain dates are approching (say one month before) within my backend database. What would be the best way to achieve this functionality? SQL Mail? Some sort of web based asp.net mail control?

Any help would be appreciated.
0
Comment
Question by:Shepwedd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24323865
well after seeing your situation, I recommend you to go for SQL mail, may be set a JOB for atomization.
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24323902
setup email in database:
http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/


After setting up email, send an email from SQL Server:
http://articles.techrepublic.com.com/5100-10878_11-6161839.html

once testing the email stored procedure whether it works, set it in JOB, you have to customize you logic based on your requirement.
http://www.ideaexcursion.com/2009/01/05/configuring-sql-server-agent-operators/


0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question