gridview auto columns

Discussion in 'ASP .Net' started by =?Utf-8?B?cm9kY2hhcg==?=, May 31, 2007.

  1. 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
     
    =?Utf-8?B?cm9kY2hhcg==?=, May 31, 2007
    #1
    1. Advertising

  2. =?Utf-8?B?cm9kY2hhcg==?=

    David Wier Guest

    Why not just turn autocolumns off and use bound fields?
    --
    David Wier
    MVP/ASPInsider
    http://aspnet101.com
    http://iWritePro.com



    "rodchar" <> wrote in message
    news:...
    > 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, May 31, 2007
    #2
    1. Advertising

  3. 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" <> wrote in message
    news:...
    > 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
     
    Eliyahu Goldin, May 31, 2007
    #3
  4. On May 31, 4:52 pm, 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


    Format the date in the select statement

    For SQL Server

    select convert(varchar,datetimefield,101) from table1
     
    Alexey Smirnov, May 31, 2007
    #4
  5. 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
     
    =?Utf-8?B?cm9kY2hhcg==?=, May 31, 2007
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jason
    Replies:
    3
    Views:
    17,171
    Jan Hyde
    May 8, 2006
  2. Jacksm
    Replies:
    2
    Views:
    892
    Paul Chalekian
    Nov 21, 2006
  3. Robson Siqueira
    Replies:
    1
    Views:
    1,469
    bruce barker
    May 1, 2007
  4. linkswanted
    Replies:
    1
    Views:
    996
  5. RBM
    Replies:
    1
    Views:
    175
Loading...

Share This Page