I have a time field in a database, and need to input: hours : minutes, from two listboxes. One listbox represents the hours, the other the minutes. I need to merge to two listbox selecteditems to form a valid time-field.
I've tried:
lstHours.SelectedItem.Value & ":" & lstMinutes.SelectedItem.Value
And others similar, but nothing seems to work.
Any suggestions?
UPDATE:
I've realised it's not a time type that's the date type that is causing the issues. The date is selected from a Calendar like so:
dbSQL_Location_Save = "INSERT INTO tblCalendar_Location (locUser, locDate, locTime, locLocation, locDescription) VALUES ('" & PublicFunctions.ConvertString(lstLocation_Staff.SelectedItem.Value) & "', '" & calLocation_Calendar.SelectedDate & "', '" & dtLocation_Time.ToString("hh:mm:ss") & "', '" & PublicFunctions.ConvertString(txtLocation_Location.Text) & "', '" & PublicFunctions.ConvertString(txtLocation_Description.Text) & "')"
Suggestions?