Formatting the date field in Data Grid

abinashpatra · April 20th, 2005, 12:06 AM

Hello,
I am reading data from Excel sheet (select * from workshee)and binding the data set to grid. I hava a date field in the excel sheet and while showing the date in grid it is coming as date time format. I want the grid to show only the date not time. How can I format the grid to show the date only? I cannot change the select statement. So I need a solution which can change the formatting in the grid.

Santhi · April 20th, 2005, 01:00 AM

Hi Check out this article..This is regarding formatting datatime in datagrid..
http://www.c-sharpcorner.com/Code/20...taGridData.asp

r_ganesh76 · April 21st, 2005, 04:01 AM

you can format the data in the grid by using a DataFormatString

Code:

<asp:BoundColumn DataField="TxnDate" HeaderText="Date" DataFormatString="{0:dd-MMM-yyyy hh:mm}"></asp:BoundColumn>

Regards
Ganesh