Date format in Datagrid

[vineethash]

I am reading in results from an SQL database one of the fields is a
date
value. I wish to be able to display the date as only "dd/mm/yyyy" in
datagird (.net)can some
body give me an example. now it showing with Date and Time

 

[Michael Nemtsev]

Hello (e-mail address removed),

Use a DataFormatString with BoundColumn

see there a description http://aspnet.4guysfromrolla.com/articles/041702-1.2.aspx

---
WBR, Michael Nemtsev [.NET/C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

 

[Riki]

I am reading in results from an SQL database one of the fields is a
date
value. I wish to be able to display the date as only "dd/mm/yyyy" in
datagird (.net)can some
body give me an example. now it showing with Date and Time

<asp:BoundColumn DataField="myDate" HeaderText="myHeader"
DataFormatString="{0:dd/MM/yyyy}" ></asp:BoundColumn>

Riki