title: I'm looking for a way to make my first column in my datagridview a header
body: <p>Ok so I have a dataset that is pulling specific cells from an excel file and populating a datagridview column. However the cells I'm pulling really need to be headers rather than normal columns in the datagridview. So is there an easy way I can turn this column of data into a header text? To help ellaborate I've provided some code below including comments.</p>
  
  <pre><code>' The following lines specify the exact cells I with to pull from the excel file and populates the first column of the datagridview
  
  MyCommand1 = New OleDbDataAdapter("Select * from [myWorksheet$A15:B21]", MyConnection)
  
  
  'Here is my dataset'
      ds1 = New System.Data.DataSet()
  DataGridView1.DataSource = ds1.Tables(0).DefaultView
  'So at this point I have a datagridview with a column of data from the exact cells 
  ' from the excel file that I want
  
  
  'This last part is code I found on MSDN which will hide the column headers and will turn the first column into headertext. Essentially it is adding an additional column to the left and turning that into headertext. 
  
  Private Sub DataGridView8_CellPainting(sender As Object, e As DataGridViewCellPaintingEventArgs) Handles DataGridView8.CellPainting
      Dim rowNumber As Integer = 1
  
      For Each row As DataGridViewRow In DataGridView8.Rows
          If row.IsNewRow Then Continue For
          row.HeaderCell.Value = "Row " &amp; rowNumber
          rowNumber = rowNumber + 1
      Next
      DataGridView8.AutoResizeRowHeadersWidth( _
          DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders)
  End Sub
  
  'If anyone can find out a way for me to make the first column headertext it would make my day. 
  </code></pre>