vb.net Changing datagridview column header name

Question

I have a problem when try to change datagridview`s column header name.

After i changed the column header name from name Column 1 to Year i am trying to get the value of the cell of that column with command

row.cells("HEADERNAME").value

and it says that Year column cannot be found. I tried the command to row.cells("Column1").value after is changed to Year and it works .

whys that ? is there anything else i have to do in order to save changes ? i can see that the column header name is changed normaly.

If you want to change the name of a column, use the name property: Me.DataGridView1.Columns(i).Name = "Year" — Bjørn-Roger Kringsjå
– Bjørn-Roger Kringsjå, Commented Aug 16, 2015 at 7:50

lc. · Accepted Answer · 2015-08-16 08:09:29Z

1

The text in the header, and the column name are two different entities. Changing one does not automatically change the other.

You should refer to the column by it's name, as you have discovered:

row.Cells("Column1").Value

Alternatively, if you want to change the name of the column, you can do so. Assuming you have an underlying DataTable as a data source:

dataTable.Columns("Column1").Name = "MyNewName"

If it's not a data table, you should be able to change the name directly in the DataGridView:

dataGridView.Columns("Column1").Name = "MyNewName"

edited Aug 16, 2015 at 8:09

answered Aug 16, 2015 at 7:46

lc.

117k21 gold badges164 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

vbnetuser Over a year ago

so how i can change the header text and also the actual column name of a column ?

vbnetuser Over a year ago

No i dont have a datatable because i just load a csv file to datagrid and then i want to get the value according to the changed column name to insert it to my sql table

Collectives™ on Stack Overflow

vb.net Changing datagridview column header name

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related