TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Atul Rokade
NA
141
43.9k
How To Send Email at Particular day and particular time
Jan 20 2013 10:47 AM
if ((DateTime.Now.DayOfWeek== DayOfWeek.Saturday) &&(DateTime.Now.Hour==19) &&(DateTime.Now.Minute==15))
{
exportsqldatatoexcle();
emailattachment();
}
}
public void exportsqldatatoexcle()
{
string con1 = "Data Source=ADMIN\\SQLEXPRESS;Initial Catalog=PhysioCure; Integrated Security=true";
SqlConnection connection = new SqlConnection(con1);
connection.Open();
sda = new SqlDataAdapter("select PationName,RegistrationDate,ContactNo,Age,Sex,Chief_Complain,Investigation_Result,PastHistoryAny,Physical_Examination,Medications,Prognosis,Electro_Therapy,Neuro_Rehabilitation,Ortho_Rehabilitation,Cardio_Pulmonery_Rehabilitation,Sports_Rehabilitation from Physio_cureTable order by RegistrationDate desc", con1);
dt = new DataTable();
sda.Fill(dt);
DataColumnCollection dccollection = dt.Columns;
Microsoft.Office.Interop.Excel.ApplicationClass excelapp = new Microsoft.Office.Interop.Excel.ApplicationClass();
excelapp.Application.Workbooks.Add(Type.Missing);
for (int i = 1; i < dt.Rows.Count + 1; i++)
{
for (int j = 1; j < dt.Columns.Count + 1; j++)
{
if (i == 1)
{
excelapp.Cells[i, j] = dccollection[j - 1].ToString();
}
else
{
excelapp.Cells[i, j] = dt.Rows[i - 1][j - 1].ToString();
}
}
}
excelapp.ActiveWorkbook.SaveCopyAs("E:\\Winform n console\\PhysioCure\\PhysioCure\\PhysioCure\\Patient_Details.xls");
excelapp.ActiveWorkbook.Saved = true;
excelapp.Quit();
MessageBox.Show("Detail file successfully create!");
}
private void emailattachment()
{
//try
//{
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("My email id");
mail.To.Add("My frnd email id");
mail.Subject = "Sending you Patient_Details File - 1";
mail.Body = "Please Check Mail With Attachment";
System.Net.Mail.Attachment attachment;
attachment = new Attachment("E:\\Winform n console\\PhysioCure\\PhysioCure\\PhysioCure\\Patient_Details.xls");
mail.Attachments.Add(attachment);
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("My email id", "Password");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
MessageBox.Show("Details File send on your mail please check your mail");
Reply
Answers (
1
)
How to call .cs file in HTML using javascript/AJAX concept??
what is wrong in this simple procedure ?