title: ComboBox on returning only one Item c#
body: <p>I am Selecting data from a database using SQL commands, I want to select data from a table to be read in a combox but it seems the combox only displays one item instead of all Items in that particular column.</p>
  
  <p>Here is my sql statement:</p>
  
  <pre><code>public void SelectEmployee()
          {
  
              Query = "SELECT Employee_Name FROM TblEmployees";
              reader = conn.ExecuteStatement(Query);
              while (reader.Read())
              {
  
                  ComboBox1.Text = reader["Employee_Name"].ToString();
  
              }
  
              conn.CloseConnection();
  
          }
  </code></pre>
  
  <p>This runs smoothly , the comboBox only shows one name though instead of 10 names.</p>