title: ComboBox Display Member on multiple fields
body: <p>I'm trying to set the<code>.DisplayMember</code> property of a <code>ComboBox</code> in C#, but I want to bind it to multiple columns in the <code>.DataSouce</code>.</p>
  
  <p>My SQL looks like this:</p>
  
  <pre><code>SELECT PersNbr, PersFirstName, PersMiddleName, PersLastName
  FROM Pers WHERE PersNbr = :persNbr;
  </code></pre>
  
  <p>I'm saving this query in a <code>DataTable</code> so each column selected has it's own column in the <code>Datatable</code>.</p>
  
  <p>I want to make the <code>.DisplayMember</code> a combination of <code>PersFirstName + PersMiddleName + PersLastName</code> so their full name appears like this:</p>
  
  <pre><code>comboBox.DisplayMemeber = "PersFirstName" + "PersMiddleName" + "PersLastName"
  </code></pre>
  
  <p>I know I can just to this on the query:</p>
  
  <pre><code>SELECT PersNbr, (PersFirstName || PersMiddleName || PersLastName) PersName
  </code></pre>
  
  <p>and then just do this: </p>
  
  <pre><code>comboBox.DisplayMember = "PersName";
  </code></pre>
  
  <p>but I don't want to do the formatting of data in the database layer since it's not supposed to be there.</p>
  
  <p>How else can I achieve this in Winforms?</p>