Get column data from sql database and store in label/string
<p>i'm intent to retrieve only column data from SQLdatabase and store in a string or label as a holder.</p>

<p><strong>CASE:</strong>
select all the email address from the database "tblUser" WHERE apple = 1 and store in a "emaillist" string holder,then attach with mail.to.add(emaillist); </p>

<p><strong>Note:</strong>
ExecuteScalar only allow me to retrieve 1st row of my database. Consequently only first row of email address is able to retrieve. (E.g.,user@user.com)</p>

<p><strong>Expect Result:</strong>
emaillist which consist of "user@user.com,testing.gmail.com,admin@admin.com" and so on.</p>

<p><strong>My code:</strong></p>

<pre><code>     String status = "1";
    SqlConnection conn100 = new SqlConnection("Server=localhost;Integrated                     Security=true;database=WebsiteDatabase");
    conn100.Open();
    SqlCommand cmd100 = conn100.CreateCommand();
    cmd100.CommandText = "select emailaddress from tblUser where apple= '" + status + "'";
        string selected100 = cmd100.ExecuteScalar().ToString();

        String emailcontent = "";
        emailcontent = "" + selected1 + "- Highlight: " + selected2;
        String emaillist = "" + selected100;
        //Create a new MailMessage in order to send email
        MailMessage mail = new MailMessage();

        //The recipient of this email
        mail.To.Add("recipient@gmail.com" + emaillist);

        //The sender of this email
        mail.From = new MailAddress("sender@gmail.com");

        //The subject of this email
        mail.Subject = "Latest Product";

        //The email's content
        string body = "New Product added! " + emailcontent;
        mail.Body = body;
        mail.IsBodyHtml = true;

        //Create new smtpClient and use smtp services
        SmtpClient smtp = new SmtpClient();

        //SMTP host (Gmail)
        smtp.Host = "smtp.gmail.com";

        //SMTP port
        smtp.Port = 587;
        smtp.UseDefaultCredentials = false;

        //Sender Email and password
        smtp.Credentials = new System.Net.NetworkCredential("sender@gmail.com", "password");

        //Enable SSL in order to have secure transmission
        smtp.EnableSsl = true;

        //Send the email
        smtp.Send(mail);
</code></pre>
