title: Gridview - Use first row of returned data as header
body: <p>This is so obvious that I hate to ask, and the only similar question I can find on StackOverflow has a -2 rating. But I can't figure it out, so here goes:</p>
  
  <p>My codebehind (C#) gets data from an Excel spreadsheet and stores it in a DataSet. My gridivew uses the DataSet as a DataSource. Works fine, but my header names are just "F1", "F2"....  </p>
  
  <p>Can I set the first row of data as my gridview header? I can't hard-code my headers because the format of the Excel file can change, and I can't control that. What I need is for my first row of data to appear as the gridview header.</p>
  
  <p>Any help? I can post some of my code if necessary, but this seems like pretty generic question.</p>
  
  <p>Any help would be much appreciated.</p>