Auto Email Send

[Sarfaraj Ahmed]

Hello SQL Server Databse keeps order information. I want to send an automatic email to customer if order has been placed. Any Solution Thanks Sarfaraj

Sarfarj Ahmed

[Lost User]

Yeah, the solution would be to automatically send an email when the order is placed. Might want to do that somewhere around your insert statement in your code, since that's probably where the order is complete in your end.

[Christian Graus]

Did you consider trying to write some code to do this ? I don't see what SQL Server has to do with it.

Christian Graus Driven to the arms of OSX by Vista.

[Ranjit Viswakumar]

It is difficult and complicated to setup SQL database triggers to send email when the database is updated. You would also have to run a local SMTP server on the SQL server which is often discouraged. The best thing to do would have your code update the SQL database, check to see if it was successful, and then use the SmtpMail class to send mail- http://quickstarts.asp.net/QuickStartv20/util/classbrowser.aspx?assembly=System.Web,%20Version=2.0.0.0,%20Culture=neutral,%20PublicKeyToken=b03f5f7f11d50a3a&namespace=System.Web.Mail&class=SmtpMail[^] Good luck! Ranjit Viswakumar Professional Services Specialist HostMySite.com[^]

[Sarfaraj Ahmed]

Thank you very much, i will folloe your instruction.

Sarfarj Ahmed

[Sarfaraj Ahmed]

could you please give some instruction

Sarfarj Ahmed