Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > gridview auto columns

Reply
Thread Tools

gridview auto columns

 
 
=?Utf-8?B?cm9kY2hhcg==?=
Guest
Posts: n/a
 
      05-31-2007
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
 
Reply With Quote
 
 
 
 
David Wier
Guest
Posts: n/a
 
      05-31-2007
Why not just turn autocolumns off and use bound fields?
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com



"rodchar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
 
Eliyahu Goldin
Guest
Posts: n/a
 
      05-31-2007
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


"rodchar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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



 
Reply With Quote
 
Alexey Smirnov
Guest
Posts: n/a
 
      05-31-2007
On May 31, 4:52 pm, rodchar <(E-Mail Removed)> wrote:
> 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

 
Reply With Quote
 
=?Utf-8?B?cm9kY2hhcg==?=
Guest
Posts: n/a
 
      05-31-2007
thanks everyone for the many possibilities.

"rodchar" wrote:

> 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

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Shipping Auto Shipping Scheduling:car moving auto transport linkswanted ASP .Net 1 11-22-2013 07:02 AM
template columns and bound columns in gridview Vinki ASP .Net Web Controls 2 04-25-2007 04:22 PM
Align table columns with gridview columns Jacksm ASP .Net 2 11-21-2006 09:49 PM



Advertisments