title: How to bind two columns values in dropdown with separate comma(,)
body: <p>I have a asp.net application in that I am using ado.net entity framework in which I want to bind the two column in that dropdown.for example:</p>
  
  <p>in database their two column of First_name ,Last_name .I want these two columns value come in a single dropdown using C#.</p>
  
  <p>How to do that?</p>
  
  <pre><code>public void BindClients()
  {
      //To Bind the Client Names for Searching Option
      var ddlclientnames = (from ddl in mortgageentity.Clients select ddl).ToList();
      if (ddlclientnames.Count() &gt; 0)
      {
          ddlsearchclient.DataSource = ddlclientnames;
          ddlsearchclient.DataValueField = "Client_ID";
          ddlsearchclient.DataTextField = "LastName";
          ddlsearchclient.DataBind();
      }
  }
  </code></pre>