Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > asp .net > answers

Notify by sending an email automatically

Newbie
  
Join Date: Sep 2009
Posts: 7
#1: 2 Weeks Ago
Hi all,

I am using ASP.NET & SQL Server 2005. Whenever there are changes in database, I need to send an email automatically to administrator.

I am very please if you can tell me how I can "send an email automatically to administrator" when programming with C#?

Thank you very much!
best answer - posted by Frinavale
I don't see how this has anything to do with ASP.NET
It seems to me that you are interested in configuring your MS SQL server to send an email when an event happens (like insert or update). You can do this using Triggers.

Check out this article on Creating Email Triggers in SQL Server 2005.

-Frinny

tlhintoq's Avatar
Moderator
  
Join Date: Mar 2008
Location: Arizona, USA
Posts: 1,781
#2: 2 Weeks Ago

re: Notify by sending an email automatically

I would recommend you start with just sending an email.
Learn how to do that much. Then worry about the 'automatic' part, and reacting to a database change secondly.
Frinavale's Avatar
Site Moderator
  
Join Date: Oct 2006
Location: The Great White North
Posts: 5,137
#3: 2 Weeks Ago

re: Notify by sending an email automatically

I don't see how this has anything to do with ASP.NET
It seems to me that you are interested in configuring your MS SQL server to send an email when an event happens (like insert or update). You can do this using Triggers.

Check out this article on Creating Email Triggers in SQL Server 2005.

-Frinny
Newbie
  
Join Date: Sep 2009
Posts: 7
#4: 4 Days Ago

re: Notify by sending an email automatically

Thank you Mr Frinny! It helps me a lot ^^
Reply

Tags
email, notificate

« previous question | next question »

Similar ASP.NET bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved