Tried several times but i am not getting excel file in mail

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi,
You are doing good
Use debug and check where your code break.
0
Vinay Singh10y ago
Try the below links
http://www.c-sharpcorner.com/article/create-excel-file-on-the-fly-and-send-as-an-email-attachment/
http://www.aspsnippets.com/Articles/Export-GridView-data-to-Excel-and-send-Excel-File-as-email-attachment-in-ASPNet.aspx
http://forums.asp.net/t/1675553.aspx?How+to+fetch+data+from+db+to+an+excel+file+and+send+as+attachment
0
Manas Mohapatra10y ago
Please find below mistakes:

You put MailMessage object inside for loop reader.FieldCount. As per code, it is sending multiple emails. Are you sure that you are sending multiple mails? If no then keep it outside of loop.

Secondly you are not attaching any files to your email. Please find below links:

http://www.aspsnippets.com/Articles/How-to-send-email-with-attachment-in-ASPNet.aspx

http://www.c-sharpcorner.com/UploadFile/sourabh_mishra1/sending-an-e-mail-with-attachment-using-Asp-Net/
0