Renaming column header in DataGridView Control using vb.net

Question

I tried out the following code but the columns still inherit the table's field names

   DataGridView1.DataSource = ds.Tables("student_attendance_table")
    With DataGridView1
        .RowHeadersVisible = False
        .Columns(0).Name = "Register No."
        .Columns(1).Name = "Date"
        .Columns(2).Name = "Year"
        .Columns(3).Name = "Batch"
        .Columns(4).Name = "Hour 1"
        .Columns(5).Name = "Hour 2"
        .Columns(6).Name = "Hour 3"
        .Columns(7).Name = "Hour 4"
        .Columns(8).Name = "Hour 2"
        .Columns(9).Name = "Attendance"
    End With

Content follows:

1138M0345   27-07-2013  3   1   P   P   P   P   P   P
1138M0346   27-07-2013  3   1   P   P   P   P   P   P
1138M0347   27-07-2013  3   1   P   P   P   P   P   P
1138M0348   27-07-2013  3   1   P   P   P   P   P   P
1138M0349   27-07-2013  3   1   P   P   P   P   P   P
1138M0350   27-07-2013  3   1   P   P   P   P   P   P
1138M0343   27-07-2013  3   1   A   A   A   A   A   A
1138M0344   27-07-2013  3   1   A   A   A   A   A   A

Also I need to sort the content in ascending order using REGNO (The first column)

I am using vb.net

bansi · Accepted Answer · 2013-07-27 06:45:58Z

11

To change the column header use the .HeaderCell.Value = "Display Value"

DataGridView1.DataSource = ds.Tables("student_attendance_table")
    With DataGridView1
        .RowHeadersVisible = False
        .Columns(0).HeaderCell.Value = "Register No."
        .Columns(1).HeaderCell.Value = "Date"
        .Columns(2).HeaderCell.Value = "Year"
        .Columns(3).HeaderCell.Value = "Batch"
        .Columns(4).HeaderCell.Value = "Hour 1"
        .Columns(5).HeaderCell.Value = "Hour 2"
        .Columns(6).HeaderCell.Value = "Hour 3"
        .Columns(7).HeaderCell.Value = "Hour 4"
        .Columns(8).HeaderCell.Value = "Hour 2"
        .Columns(9).HeaderCell.Value = "Attendance"
    End With

and for initial sorting you can use

DataGridView1.Sort(DataGridView1.Columns(0), System.ComponentModel.ListSortDirection.Ascending)

answered Jul 27, 2013 at 6:45

bansi

57.3k6 gold badges44 silver badges52 bronze badges

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

Comments

Akhil Ratheesh · Accepted Answer · 2015-02-23 07:07:23Z

0

or SELECT rollno as 'RollNo', name as 'Name', class as 'Class' FROM student_tbl this will rename the header

answered Feb 23, 2015 at 7:07

Akhil Ratheesh

11 bronze badge

Comments

TrikkStar · Accepted Answer · 2016-07-27 13:44:34Z

0

Alternatively "Data Grid Object".Columns("column index").HeaderText = "value" works as well.

answered Jul 27, 2016 at 13:44

TrikkStar

113 bronze badges

Comments

fefe · Accepted Answer · 2017-08-28 10:11:39Z

0

DataGridView1.DataSource = ds.Tables("student_attendance_table")
    With DataGridView1
        .RowHeadersVisible = False
        .Columns(0).HeaderText = "Register No."
        .Columns(1).HeaderText  = "Date"
        .Columns(2).HeaderText  = "Year"
        .Columns(3).HeaderText  = "Batch"
        .Columns(4).HeaderText  = "Hour 1"
        .Columns(5).HeaderText  = "Hour 2"
        .Columns(6).HeaderText  = "Hour 3"
        .Columns(7).HeaderText  = "Hour 4"
        .Columns(8).HeaderText  = "Hour 2"
        .Columns(9).HeaderText  = "Attendance"
    End With

Try this, I used same. Working for me!

edited Aug 28, 2017 at 10:11

fefe

3,4622 gold badges27 silver badges47 bronze badges

answered Aug 28, 2017 at 9:17

Manish Patil

11

4 Comments

Wesley Coetzee Over a year ago

Maybe add some explanation

Evry1falls Over a year ago

@WesleyCoetzee, Is this explanation satisfied ?

Wesley Coetzee Over a year ago

@evry1falls - Unless I'm not seeing it, but this has no explanation.

Evry1falls Over a year ago

The above answer and this answer are both suitable for Renaming column header in DataGridView Control using vb.net

Collectives™ on Stack Overflow

Renaming column header in DataGridView Control using vb.net

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related