title: how to store all employee names in single textbox
body: <p>While working on this code I am getting single EmployeeName in textbox but instead of that I want all Employee Names from dataset in single textbox.Thanks for help.</p>
  
  <pre><code>public void loadnow()
  {
  
      cn = new SqlConnection(str);
      cn.Open();
      cmd = new SqlCommand("select EmployeeName=[EmployeeFirstName]+' '+[EmployeeLastName] from EmployeeMaster ", cn);
      cmd.ExecuteNonQuery();
      da = new SqlDataAdapter(cmd);
      ds = new DataSet();
      da.Fill(ds);
      if (ds.Tables[0].Rows.Count &gt; 0)
      {
  
          foreach (DataRow myRow in ds.Tables[0].Rows)
          {
              StringBuilder sb = new StringBuilder();
              sb.Append(ds.Tables[0].Rows[0]["EmployeeName"].ToString());
              sb.Append(Environment.NewLine);
              TextBox1.Text = sb.ToString();
  
          }
  
          cn.Close();
      }
  }
  </code></pre>