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_Click(object sender, EventArgs e)
{
try
{
string timeNum = txtTimeControlNum.Text;
string dateCreated = DateTime.Today.ToShortDateString();
string createdby = System.Web.HttpContext.Current.User.Identity.Name;
DateTime requestedOn = txtrequestedOn.SelectedDate;
DateTime serviceDate = txtserviceDate.SelectedDate;

string customerID = ddlCust.SelectedValue;
string employeeID = ddlEmp.SelectedValue;
string hourIn = txthourIn.Text;
string hourOut = txthourOut.Text;
string place = txtPlace.Text;
string jobDesc = txtJobdesc.Text;
string materials = txtMaterials.Text;
string comments = txtComments.Text;
string travelTime = txtTravelTime.Text;
string laborHour = txtLaborhours.Text;

string insertTime = "INSERT into wd_tblTimesheet(wd_timeControlNum, wd_tsDateCreated, wd_tsBy, wd_servReqOn, wd_tsServiceDate, 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=servControl;uid=sa;pwd=sa" ;
System.Data.SqlClient.SqlConnection myconn = new SqlConnection(conn);

System.Data.SqlClient.SqlCommand myCommand = new SqlCommand();
myCommand = new SqlCommand(insertTime, myconn);

myconn.Open();

myCommand.Parameters.Add("@wd_timeNumControl", SqlDbType.VarChar, 10).Value = timeNum;
myCommand.Parameters.Add("@wd_tsDateCreated", SqlDbType.DateTime, 8).Value = dateCreated;
myCommand.Parameters.Add("@wd_tsBy", SqlDbType.VarChar, 60).Value = createdby;
myCommand.Parameters.Add("@wd_servReqOn", SqlDbType.DateTime,8).Value = requestedOn;
myCommand.Parameters.Add("@wd_tsServiceDate", SqlDbType.DateTime, 8).Value = serviceDate;
myCommand.Parameters.Add("@wd_custID", SqlDbType.Int, 4).Value = customerID;
myCommand.Parameters.Add("@wd_empID", SqlDbType.Int, 4).Value = employeeID;
myCommand.Parameters.Add("@wd_tsHourIn", SqlDbType.VarChar, 20).Value = hourIn;
myCommand.Parameters.Add("@wd_tsHourOut", SqlDbType.VarChar, 20).Value = hourOut;
myCommand.Parameters.Add("@wd_tsPlace", SqlDbType.VarChar, 70).Value = place;
myCommand.Parameters.Add("@wd_tsJobDesc", SqlDbType.VarChar, 5000).Value = jobDesc;
myCommand.Parameters.Add("@wd_tsMaterials", SqlDbType.VarChar, 5000).Value = materials;
myCommand.Parameters.Add("@wd_tsComments", SqlDbType.VarChar, 5000).Value = comments;
myCommand.Parameters.Add("@wd_tsTravelTime", SqlDbType.VarChar, 20).Value = travelTime;
myCommand.Parameters.Add("@wd_tsLaborHour", SqlDbType.VarChar, 50).Value = laborHour;

myCommand.ExecuteNonQuery();

myconn.Close();

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

//Response.Redirect("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.