title: Delete rows that contains null value from dataTable
body: <p>I have a DataTable that contains 7800 rows each row contains 3 column that may have Null values if the second column is null i am deleting the entire row the problem is that even when i am deleting the row the DataTable still contain the same amount of row number wish is 7800</p>
  
  <p>the code : </p>
  
  <pre><code> string query = "Select STORE_NAME, STORE_LATITUDE, STORE_LONGTITUDE "
    +" From stores inner join contact_information on stores.STORE_ID=contact_information.CONTACT_ID "
      +" where CONTACT_TYPE_ID=1 "
        +" AND CONTACT_COUNTRY_ID="+Country
           +" AND CONTACT_CASA_ID="+Casa
              +" AND CONTACT_TOWN_ID="+Town;
      DataTable dt = new SQLHelper(SQLHelper.ConnectionStrings.KernelConnectionString).getQueryResult(query);
      dt = removeNullColumnFromDataTable(dt);
  </code></pre>
  
  <p>the function :</p>
  
  <pre><code>    public static DataTable removeNullColumnFromDataTable(DataTable dt)
     {
      for (int i = dt.Rows.Count - 1; i &gt;= 0; i--)
        {
         if (dt.Rows[i][1].ToString() == null)
             dt.Rows[i].Delete();
        }
       return dt;
     }
  </code></pre>