Professional Web Applications Themes

show just the date in a datagrid column when the datafield is an datetime field - ASP.NET General

Hi all, i'm using a datagrid to show somedata retrieved from an sql-server 2000. this datagrid contains two columns a startdate and an enddate column. i used a storedprocedure to get both dates. but when i use the following code: datagrid.datasource = selDates() datagrid.bind() both columns show the retrived datetime value. it's a little bit ugly to see.......... the only thing i need is just the date value.... does someone know how to show only the datepart in a datagrid column thanks in advance, Adil...

  1. #1

    Default show just the date in a datagrid column when the datafield is an datetime field

    Hi all,

    i'm using a datagrid to show somedata retrieved from an sql-server 2000.

    this datagrid contains two columns a startdate and an enddate column.
    i used a storedprocedure to get both dates. but when i use the following
    code:

    datagrid.datasource = selDates()
    datagrid.bind()

    both columns show the retrived datetime value. it's a little bit ugly to
    see.......... the only thing i need is just the date value....

    does someone know how to show only the datepart in a datagrid column

    thanks in advance,

    Adil


    Adil Bohoudi Guest

  2. #2

    Default Re: show just the date in a datagrid column when the datafield is an datetime field

    Set your formatting expression to be {0:d}
    "Adil Bohoudi" <adil_devhotmail.com> wrote in message
    news:R86Ya.34454$FN3.2595642news.ono.com...
    > Hi all,
    >
    > i'm using a datagrid to show somedata retrieved from an sql-server 2000.
    >
    > this datagrid contains two columns a startdate and an enddate column.
    > i used a storedprocedure to get both dates. but when i use the following
    > code:
    >
    > datagrid.datasource = selDates()
    > datagrid.bind()
    >
    > both columns show the retrived datetime value. it's a little bit ugly to
    > see.......... the only thing i need is just the date value....
    >
    > does someone know how to show only the datepart in a datagrid column
    >
    > thanks in advance,
    >
    > Adil
    >
    >

    Eric Wise Guest

Similar Threads

  1. Formatting Date in Column of DataGrid
    By Sean Rhea in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: September 26th, 03:08 PM
  2. Show Date only from DateTime in DataGrid
    By Xarky in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: May 24th, 01:06 AM
  3. Get the datafield of a column in datagrid
    By et in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: January 2nd, 08:41 AM
  4. Separated date and time or one datetime field
    By Krzysztof Piotrowski in forum PHP Development
    Replies: 0
    Last Post: April 24th, 07:12 PM
  5. get week from date/datetime field
    By Pohoda in forum Informix
    Replies: 3
    Last Post: October 2nd, 02:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139