title: Combobox with multiple columns
body: <p><strong>Scenario:</strong> I am in the process of moving an application from access to C# and on one of the forms(in access) the user is able to select a drop down that has 3 columns (ID, FirstName, LastName). Once they select from the list the ID is displayed on the drop down.</p>
  
  <p><strong>Question:</strong> Is it possible to recreate this functionality using a combo box? What alternatives can you suggest?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p><a href="http://www.freeimagehosting.net/uploads/7acfb7bb8b.jpg" rel="nofollow noreferrer">alt text http://www.freeimagehosting.net/uploads/7acfb7bb8b.jpg</a></p>
  
  <p>Dropdown is on the top left, a text box is next to it that uses the name from the last two columns of the dropdown</p>
  
  <p><strong>EDIT 2:</strong></p>
  
  <p>Since the multiple columns arent feasible is there a way to specify mutiple displaymembers to show up on the dropdown instead? For  Example: ID - FirstName LastName</p>
  
  <p>Currently a employee object is being added to the dropdown with those properties. I tried setting display member to </p>
  
  <pre><code>cmbEmp.DisplayMember ="EmployeeID " + "FirstName " + "LastName";
  </code></pre>
  
  <p>but that doesn't. Should I scrap using the employee object and just make a SQL call grabbing those concatenated together? I was attempting to reuse some code (I was given this project halfway through its completion) but it may not be feasable.</p>