title: How to not get repeated names appeared in the Combo Box c#
body: <p><img src="https://i.stack.imgur.com/trwvd.jpg" alt="enter image description here"></p>
  
  <p>I encountered a problem where I can't seem to make the names in the Combo Box appear once instead of multiple one. Is there anything in my codes that causes this problem? Any help will be greatly appreciated.</p>
  
  <p>Below is the code to link the names to the combo Box.</p>
  
  <pre><code>private void Create_EmpDetails_Load(object sender, EventArgs e)
      {
          using (satsEntities Setupctx = new satsEntities())
          {
              var viewEmpName = (from viewEN in Setupctx.employees
                                 join ufi u in Setupctx.ufis on viewEN.UFISID equals u.UFISID
                                 select new { u.EmployeeName , u.UFISID}).Distinct().ToList();
  
              cbName.DataSource = viewEmpName;
              cbName.DisplayMember = "EmployeeName";
              cbName.ValueMember = "EmployeeName";
              //cbName.ValueMember = "UFISID";
  
          }
      }
  </code></pre>