title: How to Filter out null rows from DataTable with linq?
body: <p>I have a Datable that I have built from excel data, but sometimes excel returns rows in which all the fields are null.</p>
  
  <p>I'd like to filter these out generically without regard for column names.</p>
  
  <p>I think Linq would do this nicely but having a bit of trouble getting this to happen.</p>
  
  <p>So far this is what I got:</p>
  
  <pre><code> var nonemptyrows = from r in table.AsEnumerable()
                                                from f in r.ItemArray
                                                    where f != null
                                                       select r;
  </code></pre>
  
  <p>But it's not quite there. Anyone see what I'm missing or if I'm on the wrong track?</p>
  
  <p>Thanks in advance!</p>