title: AND operator in Linq Query with DataTable
body: <p>I wanna select some records from DataTable and got to bind in Dropdown list,Sometime i have to select where acc_id =1 in dataTable , In some cases i have to select where acc_id =1 and acc_id=5 .
  how do i use &amp;&amp; operator ,The below query is working good if only one condition .if i added  AND(&amp;&amp;) operator  got nothing in Resultsets.</p>
  
  <pre><code>   DataTable dt = new DataTable();
          dt = ds.Tables[0];
          var query = from a in dt.AsEnumerable()
                      where a.Field&lt;Int64&gt;("acc_id") == 1 &amp;&amp; a.Field&lt;Int64&gt;("acc_id") == 5
                      select a;
  
          dt = query.CopyToDataTable();
          ddlAccount.DataSource = dt;
          ddlAccount.DataTextField = "account_name";
          ddlAccount.DataValueField = "acc_id";
          ddlAccount.DataBind();
  </code></pre>
  
  <p>Assit me.</p>