Hi
Save in Sql Database with Datatype Time(7)
But it is saving in Database like this - 08:30:00.0000000
Field Datatype is Time(7)
Also how to get saved value in Dropdown.
private void BindTime()
{
    DateTime StartTime = DateTime.ParseExact("08:00", "HH:mm", null);
    DateTime EndTime = DateTime.ParseExact("20:00", "HH:mm", null);
    TimeSpan Interval = new TimeSpan(0, 15, 0);
    //TimeSpan Interval = new TimeSpan(1, 0, 0);          
    ddlTimeFrom.Items.Clear();
    ddlTimeTo.Items.Clear();
    while (StartTime <= EndTime)
    {
        ddlTimeFrom.Items.Add(StartTime.ToShortTimeString());
        ddlTimeTo.Items.Add(StartTime.ToShortTimeString());
        StartTime = StartTime.Add(Interval);
    }
    ddlTimeFrom.Items.Insert(0, new ListItem("--Select--", "0"));
    ddlTimeTo.Items.Insert(0, new ListItem("--Select--", "0"));
}
 
String frTime = ddlTimeFrom.SelectedItem.Value;
var frts = TimeSpan.Parse(frTime);
String toTime = ddlTimeTo.SelectedItem.Value;
var tots = TimeSpan.Parse(toTime);
Thanks