Display time in Windows DataGridView in HH:MM:SS TT Format using C# and VB.Net

Please add a DataGridView in the Form.

You need to select the INT data from SQL Query as String DataType otherwise DataGridView will give you conversion error.

C#

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        dataGridView1.AutoGenerateColumns = true;
        dataGridView1.AllowUserToAddRows = false;
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Time", typeof(string)) });
        dt.Rows.Add(1, 50);
        dt.Rows.Add(2, 60);
        dt.Rows.Add(3, 62);
        dt.Rows.Add(4, 90);
        dataGridView1.DataSource = dt;
        foreach (DataGridViewRow row in dataGridView1.Rows)
        {
            int time = Convert.ToInt32(row.Cells[1].Value);
            var timeSpan = TimeSpan.FromMinutes(time);
            int hh = timeSpan.Hours;
            int mm = timeSpan.Minutes;
            int ss = timeSpan.Seconds;
            string hours = hh.ToString().Length == 1 ? hh.ToString().PadLeft(2, '0') : hh.ToString();
            string minutes = mm.ToString().Length == 1 ? mm.ToString().PadLeft(2, '0') : mm.ToString();
            string seconds = ss.ToString().Length == 1 ? ss.ToString().PadLeft(2, '0') : ss.ToString();
            row.Cells[1].Value = string.Format("{0}:{1}:{2}", hours, minutes, seconds);
        }
    }
}

VB.Net

Private Sub Form1_Load(sender As Object, e As EventArgs)
	dataGridView1.AutoGenerateColumns = True
	dataGridView1.AllowUserToAddRows = False
	Dim dt As New DataTable()
	dt.Columns.AddRange(New DataColumn(1) {New DataColumn("Id", GetType(Integer)), New DataColumn("Time", GetType(String))})
	dt.Rows.Add(1, 50)
	dt.Rows.Add(2, 60)
	dt.Rows.Add(3, 62)
	dt.Rows.Add(4, 90)
	dataGridView1.DataSource = dt
	For Each row As DataGridViewRow In dataGridView1.Rows
		Dim time As Integer = Convert.ToInt32(row.Cells(1).Value)
		Dim timeSpan__1 = TimeSpan.FromMinutes(time)
		Dim hh As Integer = timeSpan__1.Hours
		Dim mm As Integer = timeSpan__1.Minutes
		Dim ss As Integer = timeSpan__1.Seconds
		Dim hours As String = If(hh.ToString().Length = 1, hh.ToString().PadLeft(2, "0"C), hh.ToString())
		Dim minutes As String = If(mm.ToString().Length = 1, mm.ToString().PadLeft(2, "0"C), mm.ToString())
		Dim seconds As String = If(ss.ToString().Length = 1, ss.ToString().PadLeft(2, "0"C), ss.ToString())
		row.Cells(1).Value = String.Format("{0}:{1}:{2}", hours, minutes, seconds)
	Next
End Sub

Screenshot

SQL Query

SELECT Id, CAST(Number as VARCHAR(50)) Time FROM Temp