how to send automatic notification to email subscribers

how to create the windows services  which looks for the table automatically whether a new data has arrived or not?

What my advise  is that write a winservice whichlooks for the table whether a new dat(a new news has arrived) the using following code to send the mail

SmtpClient smtpClient = new SmtpClient("mail.MyWebsiteDomainName.com", 25);  smtpClient.Credentials = new System.Net.NetworkCredential("[email protected]", "myIDPassword"); smtpClient.UseDefaultCredentials = true; smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network; smtpClient.EnableSsl = true; MailMessage mail = new MailMessage();  //Setting From , To and CC mail.From = new MailAddress("info@MyWebsiteDomainName", "MyWeb Site"); mail.To.Add(new MailAddress("info@MyWebsiteDomainName")); mail.CC.Add(new MailAddress("[email protected]"));  smtpClient.Send(mail);