title: GridView is not displaying all columns in DataTable
body: <p>I have a DataTable that is populated by an MDX query. I want to bind that DataTable to a GridView and show all data that is returned. My GridView is defined like this: </p>
  
  <pre><code>&lt;asp:GridView ID = "gvResults" runat="server" AutoGenerateColumns="true" /&gt;
  </code></pre>
  
  <p>MDX query is called as follows: </p>
  
  <pre><code>DataTable mdxResults = new DataTable();
  CellSet cellSet;
  
  AdomdCommand command = new AdomdCommand();
  
  strCommand = "SELECT NON EMPTY({[Measures].[Assets Distinct Count], [Measures].[Value]}) " + 
  "ON COLUMNS, NONEMPTY({[Organization].[Org Id].[Org Id]*[Location].[Loc Id].[Loc Id]}) " + 
  "ON ROWS FROM [database]"
  
  command.Connection = _CurrentConnection;
  command.CommandText = strCommand;
  cellSet = command.ExecuteCellSet();
  AdomdDataAdapter dataAdapter = new AdomdDataAdapter(command);
  objDataAdapter.Fill(mdxResults);
  </code></pre>
  
  <p>An example of a DataTable that could be produced from the MDX query:</p>
  
  <pre><code>Organization   Location      Assets     Value
  Org A          Los Angeles   12         320000
  Org B          San Jose      6          21000
  </code></pre>
  
  <p>Assets and Value are aggregated measures from the MDX query.</p>
  
  <p>The DataTable is then bound to the GridView after I rename columns:</p>
  
  <pre><code>gvResults.DataSource = mdxResults;
  gvResults.DataBind();
  </code></pre>
  
  <p>After I bind the DataTable only a subset of the columns display in the GridView. Specifically, all columns but  the Measure columns from the MDX query will display. </p>
  
  <p>Any help would be appreciated.</p>