• NA
  • 716
  • 1m

Dropdownlist shows more characters than there is in sql tabl

Sep 9 2014 4:54 PM


I have a dropdownlist which is bound to sql table's column containing time type In the table it is displayed with 8 characters and when I open the dropdown list it lists them with additional zeroes at the end

I tried with

DropDownList4.DataTextField = "TimeFrom".Substring(0, 8);

but nothing changed

Can anybody help me please how to solve this? I want only this format hh:mm:ss as it is in the sql table or only hh:mm

Thank you in advance

Answers (3)