how to send mail the excel data from the folder

narasiman rao

My code as follows

SqlConnection sqlConnection = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
DataSet ds = new DataSet();
cmd.CommandText = "select * from Empdetails";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection;
sqlConnection.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
using (System.IO.StreamWriter fileOutput =
new System.IO.StreamWriter(@"C:\Users\God\Desktop\DataDump\Excel.xls"))
{
while (reader.Read())
{

for (int i = 0; i < reader.FieldCount; i++)
{
fileOutput.AutoFlush = true;
fileOutput.Write(reader[i].ToString() +"\t");
}
fileOutput.Write("\n");
}
}
sqlConnection.Close();
}

when i execute the above code select * from Empdetails ouput is saved in the below folder

C:\Users\God\Desktop\DataDump\Excel.xls

i want to send the above excel file to send mail.

for that how can i do in asp.net using c#

What I have tried:

how to send mail the excel data from the folder.

4 Replies

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

Tapan Patel10y ago
Joginder Banger/Manas Mohapatra,
I have been trying the code you guys have posted using C# and it keeps throwing error - Failure Sending mail.

I know this is generic code which most of the people are using but somehow I am getting the exception and the exception classes are SmtpException -> WebExcetption ->SocketException.

Any idea why?
0
Prabu Elavarasan10y ago
Hi
Please take a look at the below URL:
http://www.codeproject.com/Tips/165548/C-Code-snippet-to-send-an-Email-with-attachment-fr
0
Joginder Banger10y ago
Hi Rao,
I hope you save data in excel file is that right?
MailMessagemail=newMailMessage();
SmtpClientSmtpServer=newSmtpClient("smtp.gmail.com");
mail.From=newMailAddress("[email protected]");
mail.To.Add("to_address");
mail.Subject="TestMail-1";
mail.Body="mailwithattachment";
System.Net.Mail.Attachmentattachment;
attachment=newSystem.Net.Mail.Attachment("Yourattachmentfilepath");
mail.Attachments.Add(attachment);
SmtpServer.Port=587;
SmtpServer.Credentials=newSystem.Net.NetworkCredential("username","password");
SmtpServer.EnableSsl=true;
SmtpServer.Send(mail);
MessageBox.Show("mailSend");
0
Manas Mohapatra10y ago
Follow below code:
using System.Net;
using System.Net.Mail;

public void email_send()
{
    MailMessage mail = new MailMessage();
    SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
    mail.From = new MailAddress("your [email protected]");
    mail.To.Add("[email protected]");
    mail.Subject = "Test Mail - 1";
    mail.Body = "mail with attachment";

    System.Net.Mail.Attachment attachment;
    attachment = new System.Net.Mail.Attachment("c:/Files/test.xls");
    mail.Attachments.Add(attachment);

    SmtpServer.Port = 587;
    SmtpServer.Credentials = new System.Net.NetworkCredential("your [email protected]", "your password");
    SmtpServer.EnableSsl = true;

    SmtpServer.Send(mail);

}
Note: You might need to change in Password, Email server domain, user name etc..
0