date display memeber in combobox

twaghorn · July 12th, 2003, 08:19 AM

Hi there,

My combobox datasource is a table from the database. The display member for the combobox is a date field. At database level this field is in short date format. However, when display in the combobox this field is displayed in long date format. How can I get the date displayed in the correct short date format in the combobox?

When I check the XML result of the select query by running the Webservice, the time is added as 00:00:00.0000 but in the combobox the time is 12:00:00 AM.

Also, if I bound the same dataset to a datagrid, this field is displayed correctly in short date fomat.

Please help.

Many thanks in advance

tw

NotNowJohn · July 13th, 2003, 02:10 AM

You can use dropdown's DataTextFormatString property in order to format the value from data source. For display the datetime value as short date u can use:

Code:

dropDown1.DataTextFormatString="{0:d}";

...but the Soon is eclipsed by the Moon

twaghorn · July 13th, 2003, 10:14 AM

Hi, I forgot to say that I am developing window application client.

tw

Quote:

quote:Originally posted by NotNowJohn
You can use dropdown's DataTextFormatString property in order to format the value from data source. For display the datetime value as short date u can use:

Code:

dropDown1.DataTextFormatString="{0:d}";

...but the Soon is eclipsed by the Moon