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
narasiman rao
NA
519
766.8k
Tried several times but i am not getting excel file in mail
Aug 28 2016 4:41 AM
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
Reply
Answers (
3
)
Top resion to use C# languahe ?
Insert Code C# Save Null Value What is Problem ?