SqlDateTime overflow - ASP.net 2.0 C#

[lairpr]

I am having this kind of error when trying to insert a null value;

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

bellow is my code, thanks

protected void btnAddTime_Clic k(object sender, EventArgs e)
{
try
{
string timeNum = txtTimeControlN um.Text;
string dateCreated = DateTime.Today. ToShortDateStri ng();
string createdby = System.Web.Http Context.Current .User.Identity. Name;
DateTime requestedOn = txtrequestedOn. SelectedDate;
DateTime serviceDate = txtserviceDate. SelectedDate;

string customerID = ddlCust.Selecte dValue;
string employeeID = ddlEmp.Selected Value;
string hourIn = txthourIn.Text;
string hourOut = txthourOut.Text ;
string place = txtPlace.Text;
string jobDesc = txtJobdesc.Text ;
string materials = txtMaterials.Te xt;
string comments = txtComments.Tex t;
string travelTime = txtTravelTime.T ext;
string laborHour = txtLaborhours.T ext;

string insertTime = "INSERT into wd_tblTimesheet (wd_timeControl Num, wd_tsDateCreate d, wd_tsBy, wd_servReqOn, wd_tsServiceDat e, wd_custID, wd_empID, wd_tsHourIn, wd_tsHourOut, wd_tsPlace, wd_tsJobDesc, wd_tsMaterials, wd_tsComments, wd_tsTravelTime , wd_tsLaborHour) ";
insertTime += " values ('";
insertTime += timeNum;
insertTime += "', '" + dateCreated;
insertTime += "', '" + createdby;
insertTime += "', '" + requestedOn;
insertTime += "', '" + serviceDate;
insertTime += "', '" + customerID;
insertTime += "', '" + employeeID;
insertTime += "', '" + hourIn;
insertTime += "', '" + hourOut;
insertTime += "', '" + place;
insertTime += "', '" + jobDesc;
insertTime += "', '" + materials;
insertTime += "', '" + comments;
insertTime += "', '" + travelTime;
insertTime += "', '" + laborHour;
insertTime += "' )";

string conn = @"server=FMWEB; database=servCo ntrol;uid=sa;pw d=sa";
System.Data.Sql Client.SqlConne ction myconn = new SqlConnection(c onn);

System.Data.Sql Client.SqlComma nd myCommand = new SqlCommand();
myCommand = new SqlCommand(inse rtTime, myconn);

myconn.Open();

myCommand.Param eters.Add("@wd_ timeNumControl" , SqlDbType.VarCh ar, 10).Value = timeNum;
myCommand.Param eters.Add("@wd_ tsDateCreated", SqlDbType.DateT ime, 8).Value = dateCreated;
myCommand.Param eters.Add("@wd_ tsBy", SqlDbType.VarCh ar, 60).Value = createdby;
myCommand.Param eters.Add("@wd_ servReqOn", SqlDbType.DateT ime,8).Value = requestedOn;
myCommand.Param eters.Add("@wd_ tsServiceDate", SqlDbType.DateT ime, 8).Value = serviceDate;
myCommand.Param eters.Add("@wd_ custID", SqlDbType.Int, 4).Value = customerID;
myCommand.Param eters.Add("@wd_ empID", SqlDbType.Int, 4).Value = employeeID;
myCommand.Param eters.Add("@wd_ tsHourIn", SqlDbType.VarCh ar, 20).Value = hourIn;
myCommand.Param eters.Add("@wd_ tsHourOut", SqlDbType.VarCh ar, 20).Value = hourOut;
myCommand.Param eters.Add("@wd_ tsPlace", SqlDbType.VarCh ar, 70).Value = place;
myCommand.Param eters.Add("@wd_ tsJobDesc", SqlDbType.VarCh ar, 5000).Value = jobDesc;
myCommand.Param eters.Add("@wd_ tsMaterials", SqlDbType.VarCh ar, 5000).Value = materials;
myCommand.Param eters.Add("@wd_ tsComments", SqlDbType.VarCh ar, 5000).Value = comments;
myCommand.Param eters.Add("@wd_ tsTravelTime", SqlDbType.VarCh ar, 20).Value = travelTime;
myCommand.Param eters.Add("@wd_ tsLaborHour", SqlDbType.VarCh ar, 50).Value = laborHour;

myCommand.Execu teNonQuery();

myconn.Close();

this.lblMessage .Text = "New Timesheet Added.";

//Response.Redire ct("panel.aspx" );

}

catch (Exception ex)
{

lblMessage.Text = ex.Message;


}

[kenobewan]

You might try using a # either side of the time... e.g "#" + traveltime + "#", when inserting.

Hope that this helps.