hey all,
i have a gridview that have auto columns on. Well one of the fields is a
date field which shows the time by default. Is there a way to format without
the time when Auto Columns are on?
thanks,
rodchar
David Wier - 31 May 2007 17:37 GMT
Why not just turn autocolumns off and use bound fields?

Signature
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com
> hey all,
> i have a gridview that have auto columns on. Well one of the fields is a
[quoted text clipped - 4 lines]
> thanks,
> rodchar
Eliyahu Goldin - 31 May 2007 17:46 GMT
You can format dates in the database select statement.

Signature
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
> hey all,
> i have a gridview that have auto columns on. Well one of the fields is a
[quoted text clipped - 4 lines]
> thanks,
> rodchar
Alexey Smirnov - 31 May 2007 18:01 GMT
> hey all,
> i have a gridview that have auto columns on. Well one of the fields is a
[quoted text clipped - 3 lines]
> thanks,
> rodchar
Format the date in the select statement
For SQL Server
select convert(varchar,datetimefield,101) from table1
rodchar - 31 May 2007 19:07 GMT
thanks everyone for the many possibilities.
> hey all,
> i have a gridview that have auto columns on. Well one of the fields is a
[quoted text clipped - 3 lines]
> thanks,
> rodchar