Mail.To

[crxcte1]

The code below catches errors due to the 3rd record in the database being empty. I know this is too simple but its getting the best of me.

while (drMembers.Read()) {
MyMail.To = drMembers.GetString(0);
if (MyMail.To != "") SmtpMail.Send(MyMail);
MyMail.To = drMembers.GetString(1);
if (MyMail.To != "") SmtpMail.Send(MyMail);
MyMail.To = drMembers.GetString(2);
if (MyMail.To != "") SmtpMail.Send(MyMail);
}

 

[oppcos]

The datareader GetString() method does not do a conversion, which means that the database entry must already be a string or an exception is thrown. A database null value is not considered a string so use SqlDataReader.IsDBNull() to test before using it. Perhaps better yet, do something like this:

drMembers["index_name"].ToString()

to convert it in one quick swoop, in case you don't care to do anything special if it is empty.