Save in Sql database

Ramco Ramco

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);

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.

Thanks

2 Replies

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

Jose Hernandez4y ago
Hooo also the value "08:30:00.0000000" is correct,
Hour, minutes and seconds from 08:30:00.
Milliseconds from the last onesa after the last dot: 0000000.

Anyways I'd use DateTime, check my last anwser, of course it is just a reommendation.
Jose Hernandez4y ago
I dont know if timespan dataype is the best option, but maybe you can use DATETIME datatype then just concatenate a null date with the time, something like:

DateTime TimeV = Convert.ToDateTime("01-01-0001 T" + "TimeSpanValueASString");

and save it like that in DB. To read the time back you can split the date and get the just the time using something like the following:

var TimeVFromDb as string = DateTimeVariable.ToString("HH:mm");

Some other formats to convert DateTime variable to Time:
dt.ToString("HH:mm"); // 07:00
dt.ToString("hh:mm tt"); // 07:00 AM
dt.ToString("H:mm"); // 7:00 // 24 hour clock