Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Tried several times but i am not getting excel file in mail
narasiman rao
Aug 28 2016 4:41 AM
290
Reply
nt count = 0;
string connectionstring = "Server=(local);initial catalog=Test;Trusted_Connection=True";
SqlConnection sqlConnection = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
DataSet ds = new DataSet();
cmd.CommandText = "select * from Empdetails";
cmd.CommandText += " where shifttype = @par ";
cmd.Parameters.Add("@par", SqlDbType.Int).Value = j;
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection;
sqlConnection.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
System.IO.StreamWriter sw_In = new System.IO.StreamWriter(@"C:\Users\God\Desktop\DataDump\" + j + "Excel.xls");
while (reader.Read())
{
if (count == 0)
{
for (int i = 0; i < reader.FieldCount; i++)
{
MailMessage mis = new MailMessage();
SmtpClient smtpserver = new SmtpClient("smtp.gmail.com");
smtpserver.Credentials = new System.Net.NetworkCredential("id", "password");
smtpserver.Host = "smtp.gmail.com";
smtpserver.Port = 587;
smtpserver.EnableSsl = true;
mis.From = new MailAddress("
[email protected]
", "Report");
mis.IsBodyHtml = true;
mis.To.Add("
[email protected]
");
mis.CC.Add(new MailAddress("
[email protected]
"));
mis.Subject = "Data Dump Report";
smtpserver.Send(mis);
sw_In.AutoFlush = true;
sw_In.Write(reader.GetName(i) + "\t");
}
sw_In.Write("\n");
count = 1;
}
for (int i = 0; i < reader.FieldCount; i++)
{
sw_In.AutoFlush = true;
sw_In.Write(reader[i].ToString() + "\t");
}
sw_In.Write("\n");
}
}
sqlConnection.Close();
reader.Close();
in desktop under the name of Data Dump folder excel file will be download.
i am sending that excel file to mail.
for that sending mail, i written the code above.
Mail function code as follows
MailMessage mis = new MailMessage();
SmtpClient smtpserver = new SmtpClient("smtp.gmail.com");
smtpserver.Credentials = new System.Net.NetworkCredential("id","password");
smtpserver.Host = "smtp.gmail.com";
smtpserver.Port = 587;
smtpserver.EnableSsl = true;
mis.From = new MailAddress("
[email protected]
", "Report");
mis.IsBodyHtml = true;
mis.To.Add("
[email protected]
");
mis.CC.Add(new MailAddress("
[email protected]
"));
mis.Subject = "Data Dump Report";
smtpserver.Send(mis);
but when i run the above code, in mail i getting only subject as Data Dump Report.
The excel file is i am not getting in mail.
please help me what is the mistake in my above code
What I have tried:
i tried several times to send excel file to mail using c#
ut when i run the above code, in mail i getting only subject as Data Dump Report.
The excel file is i am not getting in mail.
please help me what is the mistake in my above code
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Top resion to use C# languahe ?
Insert Code C# Save Null Value What is Problem ?