Hi All,
I am trying to insert/update the datetime field using Linq to SQL. It will show the following error
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
TimeSpan tsDays = dtTo.SelectedDate.Subtract(dtFrom.SelectedDate);
EmployeeLeave empleave = new EmployeeLeave();
empleave.EmployeeID = Convert.ToInt32(cmbEmployee.SelectedItem.Value);
empleave.LeaveTypeName = cmbLeaveType.SelectedItem.Value;
empleave.IsHalfDay = (chkHalfDay.Checked) ? true : false;
empleave.IsFormal = (chkFormal.Checked) ? true : false;
empleave.Reason = txtReason.Text.Trim();
if (tsDays.Days > 0)
{
for (int i = 0; i < tsDays.Days; i++)
{
empleave.Date =dtFrom.SelectedDate.AddDays(i);
pdc.EmployeeLeaves.InsertOnSubmit(empleave);
}
}
else
{
empleave.Date = dtFrom.SelectedDate;
pdc.EmployeeLeaves.InsertOnSubmit(empleave);
}
pdc.SubmitChanges();
Please help me, what is the wrong in this source and give you suggestions