title: Two field values in Combobox displaymember and datatable C#
body: <p>I want to bind two fields together and display it in combobox.</p>
  
  <p>I have first name and last name in my database, how to display full name in combobox?</p>
  
  <p>I tried this code but I got some errors:</p>
  
  <pre><code>OracleDataAdapter names= new OracleDataAdapter("SELECT first, last FROM person", conn);
  DataTable dt = new DataTable();
  names.Fill(dt);
  dt.Columns.Add("FullName", typeof(string), "first' : ' last"); //&lt;-- error's here
  cmbCBox.DisplayMember = "FullName";
  cmbBox.DataSource = dt;
  conn.Close();
  </code></pre>
  
  <p>Error is : </p>
  
  <blockquote>
    <p>Missing operand after ':' operator.</p>
  </blockquote>