Formatting a datetime column

[David]

I am using .Net 2.0 and VS2005 with SQL server db. The datetime columns on
SQL have the date and time in them. How can I display just the short date
format (e.g. a datetime of 10/19/2006 11:23:57 AM to show as just
10/19/2006)? I do not want to use the SQL CONVERT on the query because it
affects the sorting of the column in a GridView. If I leave the date and
time together, I get the correct sort. Below is a sample of my textbox on
the GridView column:

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("updated_datetime")
%>'></asp:TextBox>

Thank you.

David

[Karl Seguin [MVP]]

Bind accepts a 2nd parameter which is the format

You can use a standard format:
http://msdn2.microsoft.com/en-us/library/az4se3k1.aspx

Bind("XXX", "{0:d}")

or a custom format:
http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

Bind("XXX", "{0:dd MM yyyy}")
Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"David" <dl*****@lifetimeinc.comwrote in message
news:ur**************@TK2MSFTNGP02.phx.gbl...

>I am using .Net 2.0 and VS2005 with SQL server db. The datetime columns on
SQL have the date and time in them. How can I display just the short date
format (e.g. a datetime of 10/19/2006 11:23:57 AM to show as just
10/19/2006)? I do not want to use the SQL CONVERT on the query because it
affects the sorting of the column in a GridView. If I leave the date and
time together, I get the correct sort. Below is a sample of my textbox on
the GridView column:

<asp:TextBox ID="TextBox1" runat="server" Text='<%#
Bind("updated_datetime") %>'></asp:TextBox>

Thank you.

David

[David]

Thanks. Do you need htmlencode="false" when you do this inside of the
BIND() ?

David

"Karl Seguin [MVP]" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
netwrote in message news:u4**************@TK2MSFTNGP03.phx.gbl...

Bind accepts a 2nd parameter which is the format

You can use a standard format:
http://msdn2.microsoft.com/en-us/library/az4se3k1.aspx

Bind("XXX", "{0:d}")

or a custom format:
http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

Bind("XXX", "{0:dd MM yyyy}")
Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"David" <dl*****@lifetimeinc.comwrote in message
news:ur**************@TK2MSFTNGP02.phx.gbl...

>>I am using .Net 2.0 and VS2005 with SQL server db. The datetime columns
on SQL have the date and time in them. How can I display just the short
date format (e.g. a datetime of 10/19/2006 11:23:57 AM to show as just
10/19/2006)? I do not want to use the SQL CONVERT on the query because it
affects the sorting of the column in a GridView. If I leave the date and
time together, I get the correct sort. Below is a sample of my textbox on
the GridView column:

<asp:TextBox ID="TextBox1" runat="server" Text='<%#
Bind("updated_datetime") %>'></asp:TextBox>

Thank you.

David

[Karl Seguin [MVP]]

don't think so...

Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"David" <dl*****@lifetimeinc.comwrote in message
news:en****************@TK2MSFTNGP04.phx.gbl...

Thanks. Do you need htmlencode="false" when you do this inside of the
BIND() ?

David

"Karl Seguin [MVP]" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
netwrote in message news:u4**************@TK2MSFTNGP03.phx.gbl...

>Bind accepts a 2nd parameter which is the format

You can use a standard format:
http://msdn2.microsoft.com/en-us/library/az4se3k1.aspx

Bind("XXX", "{0:d}")

or a custom format:
http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

Bind("XXX", "{0:dd MM yyyy}")
Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"David" <dl*****@lifetimeinc.comwrote in message
news:ur**************@TK2MSFTNGP02.phx.gbl...

>>>I am using .Net 2.0 and VS2005 with SQL server db. The datetime columns
on SQL have the date and time in them. How can I display just the short
date format (e.g. a datetime of 10/19/2006 11:23:57 AM to show as just
10/19/2006)? I do not want to use the SQL CONVERT on the query because
it affects the sorting of the column in a GridView. If I leave the date
and time together, I get the correct sort. Below is a sample of my
textbox on the GridView column:

<asp:TextBox ID="TextBox1" runat="server" Text='<%#
Bind("updated_datetime") %>'></asp:TextBox>

Thank you.

David