Looping through Email Recipients and Displaying Names 1

[net123]

Hello:

I have a web email application that sends out emails located in SQL Server 2k. I have a reader as follows in my code:

conn.Open();
dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
while(dr.Read())
{
mailer.To = dr[0].ToString();
SmtpMail.SmtpServer = "xx.xx.xx.xxx";
SmtpMail.Send(MyMailer);
}
dr.Close();
[/blue]
I tried putting something like this:

lblRecipients.Text = mailer.To;
[/blue]
After the SmtpMail.Send(MyMailer);[/blue] but nothing is listed.

Can someone tell me what I'm missing so I can display all of the names that this is being sent to?

 

[LV]

Try lblRecipients.Text += dr[0].ToString() + &quot;<br>&quot;;