Display Date and Time from Database in ASP.Net GridView using C# and VB.Net

Hi makumbi,

Please refer below sample.

HTML

<asp:GridView ID="gvDate" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateField HeaderText="CurrentDateTime">
            <ItemTemplate>
                <asp:Label ID="lblDate" runat="server" Text='<%# Bind("Duedate" , "{0:dd/MM/yyyy HH:mm tt}") %>' />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="Name" HeaderText="Name" />
    </Columns>
</asp:GridView>

Namespaces

C#

using System.Data;

VB.Net

Imports System.Data

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[] { new DataColumn("Name", typeof(string)), new DataColumn("Duedate", typeof(DateTime)) });

        dt.Rows.Add("Mudassar", DateTime.Now);
        dt.Rows.Add("John", DateTime.Now);
        gvDate.DataSource = dt;
        gvDate.DataBind();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.AddRange(New DataColumn() {New DataColumn("Name", GetType(String)), New DataColumn("Duedate", GetType(DateTime))})
        dt.Rows.Add("Mudassar", DateTime.Now)
        dt.Rows.Add("John", DateTime.Now)
        gvDate.DataSource = dt
        gvDate.DataBind()
    End If
End Sub

Screenshot