title: Get column data from sql database and store in label/string
body: <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>