title: If all rows data is null hide column
body: <p>Using MS Visual Studio 2012, Telerik, C#.ASP.NET.</p>
  
  <p>The logic I need is as follows:</p>
  
  <pre><code>If a columns data on all rows is null then hide the column
  </code></pre>
  
  <p>Basically if a column has 3 rows of data, if there all null then dont bother displaying that column, however if there is a value in 1 of them, then show the column.</p>
  
  <p>been playing around:</p>
  
  <pre><code>foreach (GridColumn columns in dgvUserResults.Columns)
  {
      if (columns != null)
      {
          columns.Visible = false;
      }
      else
      {
          columns.Visible = true;
      }
  }
  </code></pre>
  
  <p>code doesn't work of course doesnt iterate through the foreach loop just skips it.  Although not bothered about that even if it did iterate through I need a way to check if all column[name] rows are null. There a nice Telerik one liner?</p>