How to Format Date in GridView Control - .Net Articles & Samples

Search Articles Dev Forums Personalize Favorites Member Login ASP.Net Hosting

Home
Dev Articles
Sample Chapters
Dev Forum
ASP.Net Hosting
Directory Feed
Add a Listing
Link to US
Write For Us
Contact

Search Directory

ASP.Net AJAX
AJAX ToolKit
.NET Namespaces
Applications
Articles & Samples
Assembly & Controls
Community
Developer Sites
Downloads
Hosting Services
Introduction
Knowledge Base
Sample Chapters
WebCasts

ASP.NET

Applications
Articles & Samples
ASP.Net Books
ASP.Net Sites
Assembly & Controls
Downloads
Errors & Bugs
Introduction
Knowledge Base
Sample Chapters
WebCasts

VB.Net

Articles & Samples
VB.Net Books
Downloads
Errors, Bugs & Fixes
Introduction
Knowledge Base
Sample Chapters
WebCasts

C-Sharp

Applications
Articles & Samples
C-Sharp Books
C-Sharp Sites
Errors, Bugs & Fixes
Introduction
Knowledge Base
Sample Chapters
WebCasts

SQL Server

Applications
Articles & Samples
SQL Server Books
SQL Sites
Downloads
Errors, Bugs & Fixes
Introduction
Knowledge Base
Sample Chapters
SQL Software
WebCasts

More Partners >>

How to Format Date in GridView Control

Author: DevASP Team
Download Source Code : 680_FormatDate.zip

In this article I will try to explain you how you can format date in a GridView Control while binding your data to column.

To begin with this application create a new website in ASP.Net 2.0 using C# as code behind and add the following code in aspx page:

<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" AutoGenerateColumns="false" GridLines="Horizontal">

<asp:TemplateField HeaderText="Date" >

<asp:Label ID="Date" runat="server" Text='<%# Convert.ToDateTime(Eval("BookingDate")).ToString("dd/yyyy") %>'>asp:Label>

ItemTemplate>

asp:TemplateField>

Columns>

asp:GridView>

You will see that I have used the label control and itemtemplate and set its text to bind column and there I have used the Convert.ToDateTime method that will change the value to date time and will format it into the way that we want to be displayed on form. Now on page load add the following code:

SqlConnection objConn = new SqlConnection("Persist Security Info=False;User ID=sa;password=master;Initial Catalog=tempdatabase");

SqlDataAdapter objAdap = new SqlDataAdapter();

DataSet ds = new DataSet();

objConn.Open();

objAdap = new SqlDataAdapter("Select BookingDate from Ticket", objConn);

objAdap.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

objConn.Close();

You need to import the System.Data.SqlClient namespace to use the sql namespace methods.

Article Comments

Name: Jogesh Ch Nayak

I have created GridView and assign Datasource at RunTime. I need to format one Column which will have the following data.

Start_date Want to Format as Start_date
-------------- ------------------------------------------
10-Mar-2005 10:50:00 10-03-2005

Discard Time and change the Date Format.

Please anyone tell me how to achieve this.

Name: heena

hi
i have a problem if you can help me on that, that will be really appreciating. i have a gridview and i have more than on date in it and not sure where excatly the date field will fall in gridview and would like to foramte that date field as mm/dd/yyyy.
Thank you