sending mail from ASP.net

[zeza]

HI all


i MADE A REGISTRATION FORM VIA asp.nET AND i SAVE MY DATA INTO A DATABASE IN SQL SERVER

i NEED TO SEND AN EMAIL TO ADMINISTRATOR EACH TIME A NEW RECORD INSERTED TO THE DATABASE



THANKS

[MRutledge]

heres an example in C#

private void SomeFunction()
{
        // Insert Record into DataBase
        // Generate the body of the email

        string sBody = "A new record has been inserted";

        // Send the Email
        System.Web.Mail.MailMessage msg = new System.Web.Mail.MailMessage();

        msg.BodyFormat	= System.Web.Mail.MailFormat.Html;
        msg.From		= sFromEmail;
        msg.To			= sToEmail;
        msg.Subject		= sSubject;
        msg.Body		= sBody;

        System.Web.Mail.SmtpMail.Send(msg);
}

Matt

[sorret]

Best way to do it is setup a TRIGGER in the database.

You can setup an AFTER OF INSERT trigger to send an email to the administrator each time a record is sucessfully inserted in the database.

Using triggers email will be generated any time a record is inserted, regardless of how was inserted.

I hope this helps.

Sidney Orret

[zeza]

would you please tell me how can I do that

[zeza]

when I try this it sends to all the mail inside the domain but it does not send to any mail such as yahoo or hotmail