title: Linq not in select on datatable
body: <p>Hi i've got 2 data tables (bannedlist,countrylist), both contains list of country names and cods in columns cc and country. I am trying to do a query where i can select countries from countrylist table that are not in bannedlist table in order to create a 3rd table.</p>
  
  <p>Any ideas?</p>
  
  <p>I haven't got too far with this.</p>
  
  <pre><code>        var ccList = ds.Tables[2].AsEnumerable(); 
          var bannedCCList = ds.Tables[1].AsEnumerable();
          var query = from r in ccList....
  </code></pre>
  
  <p>..</p>
  
  <p>after trying </p>
  
  <pre><code>var bannedCCList = ds.Tables[1].AsEnumerable();
      var query = from r in ccList where !bannedCCList.Any(b =&gt; b["cc"] == r["cc"])select r;
  </code></pre>
  
  <p>i still get same country list. banned ones haven't been removed. here is more detail in order to explain more. not sure what i am doing wrong</p>
  
  <pre><code> protected void BindCountryBan(string subd)
  {
      DataSet ds = new DataSet();
      ds = new DB().CountryBan_GetSiteSettings();
  
          BannedCountryListBox.DataSource = ds.Tables[1];
          BannedCountryListBox.DataValueField = "cc";
          BannedCountryListBox.DataTextField = "country";
          BannedCountryListBox.DataBind();
  
  //bind country list
      var ccList = ds.Tables[2].AsEnumerable(); 
      var bannedCCList = ds.Tables[1].AsEnumerable();
      var query = from r in ccList where !bannedCCList.Any(b =&gt; b["cc"] == r["cc"])select r;
      //var query = ccList.Except(bannedCCList); 
  
  
  
  
      //CountryListBox.DataSource = ds.Tables[2];
      DataTable boundTable = query.CopyToDataTable&lt;DataRow&gt;();
      CountryListBox.DataSource = boundTable;
      CountryListBox.DataValueField = "cc";
      CountryListBox.DataTextField = "country";
      CountryListBox.DataBind();
  }
  </code></pre>