Mail is working but i want send two excel file to eachperson

My code is working, But i want the First excel send to one person and another excel to send to another person.

My code as follows

int 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)

{

string filePath = @"C:\Users\God\Desktop\DataDump\" + j + "Excel.xls";

System.IO.StreamWriter sw_In = new System.IO.StreamWriter(filePath);

while (reader.Read())

{

if (count == 0)

{

for (int i = 0; i < reader.FieldCount; i++)

{

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");

}

sw_In.Dispose();

MailMessage mis = new MailMessage();

mis.From = new MailAddress("[email protected]","Report");

mis.IsBodyHtml = true;

mis.To.Add("[email protected]");

mis.Subject = "Data Dump Report";

mis.Attachments.Add(new Attachment(filePath, "application/vnd.ms-excel"));

SmtpClient smtpserver = new SmtpClient("smtp.gmail.com");

smtpserver.Credentials = new System.Net.NetworkCredential("[email protected]", "Password");

smtpserver.Host = "smtp.gmail.com";

smtpserver.Port = 587;

smtpserver.EnableSsl = true;

smtpserver.Send(mis);

}

reader.Close();

sqlConnection.Close();

When i run the above in desktop C folder 1Excel and 2Excel to be download in that folder.

I am sending the both the excel file to mail.

That excel file is getting a mail no problem.

i am getting a both 1Excel and 2Excel to [email protected] to this mail.

But i want 1Excel file to be sent to [email protected].

And 2Excel file to be sent to [email protected].

In my above code both 1Excel and 2Excel file getting mail to [email protected].

For that what changes need to be done in my code.

Please help me.

2 Replies

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

Vinay Singh10y ago
here create a seperate function to send the email.
in this function pass the to email id and the excel file detail and. call it for number of timer you want to send
0
Dharmesh Singh10y ago
1. if(j==1)
2. {
3. mis.To.Add("[email protected]");
4. }
5. else
6. {
7. mis.To.Add("[email protected]");
8. }