Changing Format of column in Data grid view

Question

I have a data grid view that I am populating with a database as its data source. However, the columns with a date as its data type show a date and time while I only want a time.

How do I change the format of a data grid view table?

Private Sub prcDisplayTable()
    dgvViewLecturers.DataSource = Nothing
    dgvViewLecturers.Rows.Clear()
    dgvViewLecturers.Columns.Clear()

    strSQL = "SELECT * FROM Lecturers"
    strTableName = "ViewLecturers"

    daLecturers = New OleDb.OleDbDataAdapter(strSQL, con)
    daLecturers.Fill(dsLecturers, strTableName)

    dgvViewLecturers.DataSource = dsLecturers
    dgvViewLecturers.DataMember = strTableName
End Sub

yogi · Accepted Answer · 2012-07-30T05:50:40.260

1

try this for time only format

dataGridView1.Columns("dateColumn").DefaultCellStyle.Format = "hh:mm:ss tt";

edited Jul 30 '12 at 05:50

answered Jul 28 '12 at 06:17

yogi

19,175
13
62
92

score 0 · Answer 2 · answered Jul 28 '12 at 06:14

0

Set DefaultCellStyle.Format property.

 dataGridView1.Columns("dateColumn").DefaultCellStyle.Format = "hh:mm:ss t";

answered Jul 28 '12 at 06:14

KV Prajapati

93,659
19
148
186

Changing Format of column in Data grid view

2 Answers2