title: Filtering a Datatable with List c#
body: <p>I want to remove all Datatable rows containing existing sites provided in List. But the problem with my code is its only removing the last item of List from Datatable.</p>
  
  <p>Sorry for a bit ambiguity in question for first time but fixing a legacy app so have to use .net 2.0 :( I knew the problem with my logic ,was just unable to find the alternate!</p>
  
  <pre><code>DataView cView = result.DefaultView;
  
  foreach (string items in existingSites)
  {
      cView.RowFilter = "Sites &lt;&gt; '" + items + "'";
  }
  
  dgvResult.DataSource = cView;
  </code></pre>