gridview auto columns

[Guest]

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]

Why not just turn autocolumns off and use bound fields?

 

[Eliyahu Goldin]

You can format dates in the database select statement.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

 

[Alexey Smirnov]

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

Format the date in the select statement

For SQL Server

select convert(varchar,datetimefield,101) from table1

 

[Guest]

thanks everyone for the many possibilities.