string or binary data would be truncated (SQL exception)

protected void EMPLOYEERECORD_RowCommand(object sender, GridViewCommandEventArgs e)
        {

            if (e.CommandName.Equals("ADD"))
            {
                DropDownList drpDepartment = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("drpDepartment");
                DropDownList DropDownList1 = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("DropDownList1");
                DropDownList drpCategory = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("drpCategory");
                TextBox txtAddRemarks = (TextBox)EMPLOYEERECORD.FooterRow.FindControl("txtAddRemarks");
                DropDownList drpStatus = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("drpStatus");


                DatabaseModule.SQcon.Open();
                string cmdstr = "insert into dbo.RecordEmployee (DATE_REPORTED, EMPLOYEE_NAME, DEPARTMENT, CATEGORY, REMARKS, TIME_IN,  TIME_OUT, EMP_STATUS) values(@dReported, @empname,@department,@category,@remarks,@tIN, @tOUT, @status)";
                SqlCommand cmd = new SqlCommand(cmdstr, DatabaseModule.SQcon);
                cmd.Parameters.AddWithValue("@dReported", DateTime.Now.ToString());
                cmd.Parameters.AddWithValue("@empname", DropDownList1.SelectedValue.ToString());
                cmd.Parameters.AddWithValue("@department", drpDepartment.SelectedValue.ToString());
                cmd.Parameters.AddWithValue("@category",drpCategory.SelectedValue.ToString());
                cmd.Parameters.AddWithValue("@remarks", txtAddRemarks.Text);
                cmd.Parameters.AddWithValue("@tIN", DateTime.Now.ToString());
                cmd.Parameters.AddWithValue("@tOut", "");
                cmd.Parameters.AddWithValue("@status", drpStatus.SelectedValue.ToString());
                cmd.ExecuteNonQuery();
                DatabaseModule.SQcon.Close();
                BindData();
            }  
        }

create table dbo.RecordEmployee (DATE_REPORTED datetime primary key, EMPLOYEE_NAME varchar(50) NOT NULL,
                           DEPARTMENT varchar(40) NOT NULL,
                           CATEGORY varchar(20)NOT NULL, REMARKS varchar(100), TIME_IN datetime NOT NULL,
                           TIME_OUT datetime, EMP_STATUS varchar (20) NOT NULL)