Hi,
I'm new with asp.net and trying to do some code.
I have a SQL server 2005 database which contains the members' details and other tables. The members' membership is valid for one year. If they didn't renew their membership the code should send them an Email (which is given in the members' table) before 1 month of the expiry date notifying them to renew it, else it will keep sending.
I created a separate table which contains: member_id, renewal_status(bit), renewal_date(date), sending_times(small int).
It should take the renewal date (for the first time it would be the registration date) use it to check the validity, and then decide whether or not to send the mail. However, I don't know how to do so :S
I'm using ASP.net+C#.net 2008. I can connect to the database, but I don't know the next steps.. please advise.