How to add multiple email address receipients retrieved from MySQL ?

Question

0.00/5 (No votes)

See more:

Hello.

I'm getting an error on this line below :-

email = myDataReader.GetValue(i).ToString();

What I'm trying to do is just retrieve multiple email addresses from MySQL and send email.

Based on the example that I have found, it stores in the arraylist, but in my case it gives me error.

I have look on the Google but still not able to correct the error.

Could some one help me out please ? Thanks.

C#

protected void searchEmail ()
    {
         MySqlConnection con = new MySqlConnection("server=localhost;userid=root;password=;database=obsystem");
         con.Open();

         MySqlCommand cmd = new MySqlCommand("SELECT cusEmail from monthlytracker AND MONTH(paymentDate)='" + mm + "' AND YEAR(paymentDate)='" + year + "'AND status='" + Unpaid + "'",con);

         MySqlDataReader myDataReader = cmd.ExecuteReader();

         ArrayList list_emails = new ArrayList();

         int i = 0, email = 0;

         while (myDataReader.Read())
            {
                
                email = myDataReader.GetValue(i).ToString();

                list_emails.Add(email); //Add email to a arraylist

                i = i + 1 - 1; //increment or ++i

            }

            con.Close(); //Close connection

 

            foreach (string email_to in list_emails)

            {

                MailMessage mail = new MailMessage();

                mail.To.Add(email_to);

                mail.Subject = "Welcome to C#";

                mail.From = new MailAddress("");

                mail.Body = "Test";

                SmtpClient smtp = new SmtpClient("SMTP Server");

                smtp.Send(mail);

            }
    }

Posted 9-Aug-13 21:20pm

Member 9992122

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-08-09T22:36:00

Solution 1

Without the error message, I'm pretty much reduced to guessing, but the chances are that you need to authentication to your SmtpClient: Have a look at this Sending an Email in C# with or without attachments: generic routine.[^] which I know works! :laugh:

Posted 9-Aug-13 22:36pm

OriginalGriff

André Kraak · Answer 2 · 2013-08-09T22:51:00

My guess would be that the problem is that you declared email as an integer:

C#

int i = 0, email = 0;

and are trying to assign a string to it:

C#

email = myDataReader.GetValue(i).ToString();

This does not work and should be the cause of the error message.

You do not need the declaration and assignment of the email variable, just use:

C#

list_emails.Add( myDataReader.GetValue(i).ToString() );

Also I would like to note that the statement i = i + 1 - 1; has no effect and it is the same as i = i;, so this entire line could be omitted.
As the reader only has one column you are retrieving there is also no need to declare and use the i variable, so the statement to add the e-mail to the list becomes:

C#

list_emails.Add( myDataReader.GetValue( 0 ).ToString() );