Loading

Dropdownlist shows more characters than there is in sql tabl

Nel

12y1.5k.NET

Hi,

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Maruthi12y ago
cool Nel :)
0
Nel12y ago

Thanks Ramesh, but I found my error
I forgot to change the stored procedures after I changed the type time in the table
Now the problem is solved
+1
Ramesh Maruthi12y ago
DateTime result;
DateTime.TryParseExact(TimeFrom, "hh:mm", null, DateTimeStyles.AssumeLocal, out result);
0