title: Dropdown two column binding using linq
body: <p>I bind two columns into a dropdown using SQL like this</p>
  
  <pre><code>string query = "Select Id,Name+':'+Distribution_name+' 'as Name1 from BR_supervisor where( (id not in (select SupId from tbluser where active='true')) and active='true' ) ";
  
      DropDownList3.DataTextField = "Name1";
      DropDownList3.DataValueField = "Id";
      DropDownList3.DataBind();
  </code></pre>
  
  <p>Now I want to transform my query into linq expression and bind the dropdown. How to do this?</p>