Dropdown Listbox date value

[James W. Hall Sr.]

I am filling a dropdown listbox in ASP.NET. The display value is a date
field from SQL Server. When I bind the data to the dropdown listbox the
time appears in with the data (12:00 am). In the database it appear
12/31/2003. It appears in the control as 12/31/2003 12:00 am. I am
trying to format the field in the select statement with no luck. Can
anyone help me?

James W. Hall Sr.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tu-Thach]

You can specify the format string using the
DataTextFormatString property i.e. {0:"d"}

Tu-Thach

-----Original Message-----

I am filling a dropdown listbox in ASP.NET. The display value is a datefield from SQL Server. When I bind the data to the dropdown listbox thetime appears in with the data (12:00 am). In the database it appear12/31/2003. It appears in the control as 12/31/2003 12:00 am. I amtrying to format the field in the select statement with no luck. Cananyone help me?

James W. Hall Sr.
*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
.

[James W. Hall Sr.]

I tried using the datatextformatstring as you stated. I get an error
converting string to date when I selectvalue. Do you have any
suggestions? The display value is the date the value is weekid, which
is integer.

James W. Hall Sr.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tu-Thach]

It should be {0:d}. I put in the extra " around the d last time.

Tu-Thach

James W. Hall Sr. <ji*****@alpha-transportation.com> wrote in message news:<#I*************@tk2msftngp13.phx.gbl>...

I tried using the datatextformatstring as you stated. I get an error
converting string to date when I selectvalue. Do you have any
suggestions? The display value is the date the value is weekid, which
is integer.

James W. Hall Sr.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[James W. Hall Sr.]

Thank you for your time. It worked without the " but you did need the
{}.

James W. Hall Sr.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!