title: How to assign a row collection (obtained by a linq query) to a datatable without using a loop?
body: <p>I've scenario where the datatable may contain large number of rows. As a result i can't  iterate and update the datatable using a loop.</p>
  
  <p>I am using the following code to get row collection,</p>
  
  <pre><code>         from row in CSVDataTable.AsEnumerable()
           where CSVDataTable.Columns.Cast&lt;DataColumn&gt;().Any(col =&gt; !row.IsNull(col))
           select row;
  </code></pre>
  
  <p>Any one please tell me how to assign the result of the above code to a datatable without using a loop. </p>