Solved

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

Posted on 2009-05-07
2
157 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with simplifying SQL 6 50
Error on Add method 1 38
Sql query 107 29
What namespace do I need to import? 2 13
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now