vb or sql server generate email message

Sie Ste

In a change to a .net 2010 application that uses a sql server 2012 database, I am thinking of using a trigger when a duplicate record has been generated. This trigger would send outlook 2013 or office 365 email message to selected users. I am thinking of doing this instead of having the duplicate record email message sent out in the .net application. Thus would you show me the code  and/or point me to a url that will show me how to accomplish my goal?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
hi
check the code
usingSystem.Net.Mail;
...
MailMessagemail=newMailMessage("[email protected]","[email protected]");
SmtpClientclient=newSmtpClient();
client.Port=25;
client.DeliveryMethod=SmtpDeliveryMethod.Network;
client.UseDefaultCredentials=false;
client.Host="smtp.google.com";
mail.Subject="thisisatestemail.";
mail.Body="thisismytestemailbody";
client.Send(mail);
You can use the above code to send the mail after validating the duplicate record.
0
Nilesh Sawardekar10y ago
https://code.msdn.microsoft.com/windowsdesktop/VB-NET-OUTLOOK-SEND-EMAIL-4956ed06
check above link to send emails,
Also, from my opinion sending email frequently from application would create performance issues of application,since it takes 5 to 10 sec sometimes to send mail.
so, keep this in mind, before implementing.
As you know how to use triggers you can easily send data in body of email.
0
Francis Susaimichael10y ago
Try the below url:
http://asp.net-tutorials.com/misc/sending-mails/
0