edit databound datagridview column header text

[thejeraldo]

how do i change the colmun header text of a datagridview if ive set its datasource from a dataset?

dgEmpList.DataSource = ds
dgEmpList.DataMember = ds.Tables("employees").ToString

 

[jmcilhinney]

The grid has a Columns collection that you can index to get each column. You can then set its HeaderText property.

 

[jmcilhinney]

I've never tried but I believe that you can also set the Caption properties of the DataColumns in the DataTable and then the grid will use those automatically.

 

[thejeraldo]

thanks for the response guys. i know how to do it now.
i did it like this:

da = New OleDb.OleDbDataAdapter(strsql, con)
da.Fill(ds, "employees")
dgEmpList.DataSource = ds
dgEmpList.DataMember = ds.Tables("employees").ToString
dgEmpList.Columns(0).HeaderText = "Employee ID"
dgEmpList.Columns(1).HeaderText = "Last Name"
dgEmpList.Columns(2).HeaderText = "First Name"
dgEmpList.Columns(3).HeaderText = "Department"
dgEmpList.Columns(4).HeaderText = "Position"
dgEmpList.Columns(5).HeaderText = "Location"
dgEmpList.Columns(6).HeaderText = "Status"

hope this code can help anybody in the future.