Sending all mails from dataset

Sandeep Vemula

Hi, here am sending 999 mails per day.
so am getting prob while sending mail.
that is if any mail id is wrong the loop is quitting.
but i want to continue that loop until all mails i have to send.
this is my code.
(for example. these r mail ids.
[email protected], [email protected], a , abc, [email protected],[email protected].
so here am getting error at a contact. here my loop is quitting. so my req is if am get error (string is not format like this type error ) still i have to send remaining mails)
)

foreach (DataRow dr in ds.Tables[1].Rows ' here consider 999 mail ids')
{
smtpclient.Host = "s0002";
MailMessage message = new MailMessage("[email protected]", dr["Email"].ToString());
message.Body = ds.Tables[0].Rows[0]["MessageBody"].ToString();
message.Subject = "Hi Mr/Mrs,";
smtpclient.Credentials = new System.Net.NetworkCredential("", "");
smtpclient.Port = 25;
smtpclient.Send(message);
}

2 Replies

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

Jignesh Trivedi14y ago
hi,

you have two option to resolve the problem.
1) usetry.. catch
2) use regular expression for checking to address.

but i preffer first way which is already explain by Vulpes.

hope this help.
0
Vulpes14y ago
Try this instead:

smtpclient.Host = "s0002";
smtpclient.Credentials = new System.Net.NetworkCredential("", "");
smtpclient.Port = 25;
List undelivered = new List();

foreach (DataRow dr in ds.Tables[1].Rows)
{
MailMessage message = new MailMessage("[email protected]", dr["Email"].ToString());
message.Body = ds.Tables[0].Rows[0]["MessageBody"].ToString();
message.Subject = "Hi Mr/Mrs,";

try
{
smtpclient.Send(message);
}
catch(Exception ex)
{
undelivered.Add(dr["Email"].ToString());
}
}

if (undelivered.Count > 0)
{
string message = "Unable to deliver mail to the following\r\n\r\n";
message += String.Join("\r\n", undelivered.ToArray());
MessageBox.Show(message);
}
0