mysql发送消息_如何使用mysql事件自动发送消息？

I have mysql database and this database include birth day and mail adres for customers.

I write asp.net web application

I want to do every day I will check birthdays with system date if it is equal event send me birthday and mail addreses to c# code behind.so I will write multiple send mail code.

how to do that?

解决方案I will not do this using ASP.NET :) ASP.NET is not designed for such task.

Ok, here is simple solution

1. create console application which select customers who having birthday today and send email to them.

2. log in to one of your server and create windows scheduled task which running every day at given time. as a action browse and give your exe file.

Done :)

you can create window service for the same pupose that will run in backgroung and trigger an action on the predefined time and execute your logic. you can send mail at that time.