title: How to read data from two different column in same table and return in string builder?
body: <p>im having a problem in reading data from two different column in same database table.
  (Sorry for my bad english.)</p>
  
  <pre><code>String status = "1";
  
  SqlConnection conn = new SqlConnection("Server=localhost;Integrated Security=true;database=WebsiteDatabase");
  conn.Open();
  SqlCommand cmdname = conn.CreateCommand();
  cmdname.CommandText = "select product, quantity from tlbOrder where status = '1'";
  
  //get product name and quantity
  cmdname.Parameters.Add("@status", status);
  SqlDataReader dr = cmdname.ExecuteReader();
  StringBuilder sb = new StringBuilder();
  while (dr.Read())
  {
      sb.AppendFormat("{0}, ", dr[0].ToString());
  }
  
  
  label1 = ""+sb.ToString();
  </code></pre>
  
  <p>However, only "product" details are return.</p>
  
  <p>Expected results: label with string of Product name + quantity (e.g. Laptop 1, Keyboard 3, Speaker 5) and so on.</p>