title: Delete row from datatable where first column does not contain (some string)
body: <p>I have DataTable with the following columns:</p>
  
  <pre class="lang-none prettyprint-override"><code>ClientID date numberOfTransactions price
  </code></pre>
  
  <p>ClientID is of type string and I need to ensure that its contents include "A-" and "N6" for every value in the table.</p>
  
  <p>I need to delete all rows from the DataTable where this first column (ClientID) does not contain both "A-" <strong>and</strong> "N6" (some totals and other unnecessary data).  How can I select and delete these rows specifically from the DataTable?</p>
  
  <p>I know this:</p>
  
  <pre><code>foreach (DataRow row in table.Rows) // Loop over the rows.
      {
  
          //Here should come part "if first column contains mentioned values
      }
  </code></pre>
  
  <p>I also know this</p>
  
  <pre><code>If (string.Contains("A-") == true &amp;&amp;  string.Contains("N6") == true)
  
  {
  //Do something
  }
  </code></pre>
  
  <p>I need help how to implement this for first column of each row.</p>