Send Mis Report on mail

Question

Hi I have developed a MIS based project in asp.net 2.0 with sqlserver 2000. I want to send MIS Report daily by email.please help me

vivek kulkarni · Answer

Hi I belive you would be able to access fetch data with the current given permission. You can create a windows service which you can schedule to run daily. Use the System.Web.Mail here is a sample. MailMessage msgMail = new MailMessage(); msgMail.To = christophw@sleeper.Dev.AlfaSierraPapa.Com; msgMail.Cc = webmaster@sleeper.Dev.AlfaSierraPapa.Com; msgMail.From = webmaster@aspheute.com; msgMail.Subject = Hi Chris another mail; msgMail.BodyFormat = MailFormat.Html; string strBody =  Hello World  +  ASP.NET ; msgMail.Body = strBody; SmtpMail.Send(msgMail); Cheers

aryan soft · Answer

Hi Thanks for sending message. My problem is how can i schedule database bcoz i have no control over it bcoz it is running online sqlserver and i have only limited permission. Plz reply me if there is another solution

vivek kulkarni · Answer

Hi You can use Windows service to do this. You can schedule the service to run daily at a particular time. Please let me know if you require anything else. Thank you Vivek Kulkarni MCP MCAD.Net