SQL datetime format

[frank frank via DotNetMonster.com]

Hello,

When I get a value( smalldatetime data type) from MSSQL database out and
bind with dataGrid, it will display something like "19/04/2005 12:00:00
AM". Now I want it like "19/04/2005".

I'd appreciate any clue !
Franky

 

[Lars-Erik Aabech]

Set the DataFormatString property of the BoundColumn (if that's what you
use) to {0:d}. (Short date format)
(This is the Format String in the Property Builder)

There's loads of ways to format a date btw, more can be found here:
http://msdn.microsoft.com/library/d...e/html/cpconstandarddatetimeformatstrings.asp

HTH,
Lars-Erik

 

[frank frank via DotNetMonster.com]

Mr Lars-Erik Aabech , you are my hero ,
Great thanks

 

[Lars-Erik Aabech]

Glad I could help

L-E