Sending email from asp.net page to addresses in database

[fhirzall]

Hey everyone, I'm working on a project in asp.net with C#, and I'm trying to have a adminstator page in which the website owner can send a newsletter to people subscribed. How can I retrieve the email addresses from the database table and assign them to the objMail.To variable for sending?

Thanks in advance for the help.

[txbakers]

select email from table

while not RS.EOF{

populate mail object with email from db.

RS.MoveNext(); }

Just set up a loop until EOF of the email addresses.

You'll need to do it individually.

[fhirzall]

Thanks for your help txbakers, so there's no way to maybe load the emails from the db into a dataset and bind that to the mail object?