DataTextFormatString property

[bazzer]

i have a webform accessing a microsoft access database. when i display
dates i get from a table, into a listbox, their displayed in the form:
"05/04/2006 00:00:00". all i want to be displayed is the date alone.
what would i need to put in the DataTextFormatString property in my
listbox properties window to achieve this?

and is there a way to display the day, e.g. "Wednesday 05/04/2006"
before each item in the listbox even though its not stored in my access
database?

thanks,
bazzer.

 

[Guest]

There is no aplicable DataTextFormatString value for formatting dates. You
can display the day of the week by putting the value from the date field into
an object of type System.DataTime and then retrieving the DayOfWeek property.
You could also populate the textbox with just the date by using the
ToShortDateString method of the same object.

 

[Karl Seguin [MVP]]

There are a number of preexisting formats, and you always have the ability
to create your own.

You can find the existing formats here:
http://msdn.microsoft.com/library/d...e/html/cpconstandarddatetimeformatstrings.asp

Or you can use a custom format for greater control:
http://msdn.microsoft.com/library/d...ide/html/cpconcustomdatetimeformatstrings.asp

Karl

 

[bazzer]

thanks for thoses links. checked em out but not sure exactly what im
supposed to do. tryed puttin just d and also ddmmyyyy in the
DataTextFormatString but all i get then in the listbox is those exact
letters?

 

[Karl Seguin [MVP]]

try {d} I think

 

[bazzer]

i just tried that aswell but i get the error:

"Input string was not in a correct format."

from the line:
ListBox1.DataBind()

 

[bazzer]

fixed it.

{0:d} works.

thank Karl.

 

[KBuser]

{0:d} and you have to turn off html formatting for the column.