根据此代码，我得到“无效的对象名称't​​imesheetdate'。” [英] As per this code i m getting "Invalid object name 'timesheetdate'."

问题描述

根据此代码我得到无效的对象名称''timesheetdate''。

As per this code i m getting "Invalid object name ''timesheetdate''."

foreach (ManageTimeSheetsModel obj in newlist)
{
    SqlCommand cmd = new SqlCommand("Timesheet_sp", con);
 
    cmd.Parameters.Add("@EmployeeID",SqlDbType.Int).Value=obj.EmployeeID;
    cmd.Parameters.Add("@OrganisationID", SqlDbType.Int).Value = obj.OrganisationID;
    cmd.Parameters.Add("@Timesheetdate", SqlDbType.DateTime).Value = obj.Timesheetdate;
    cmd.Parameters.Add("@Workinghours", SqlDbType.Decimal).Value = obj.Workinghours;
    cmd.Parameters.Add("@Leavehours", SqlDbType.Decimal).Value = obj.Leavehours;
    cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = obj.status;
    cmd.CommandType = CommandType.StoredProcedure;
    //cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = timesheet.Email;
    SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
    result.Direction = ParameterDirection.Output;
    cmd.Parameters.Add(result);
    SqlParameter ErrorMessage = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 500);
    ErrorMessage.Direction = ParameterDirection.Output;
    cmd.Parameters.Add(ErrorMessage);

    cmd.ExecuteNonQuery();

   //int id = Convert.ToInt32(result.Value.ToString());
    
}

在模型中我已经初始化：

in the model i have intialised :

public int EmployeeID { get; set; }
public int OrganisationID { get; set; }
public decimal Workinghours { get; set; }
public decimal Leavehours { get; set; }
public string status { get; set; }
public DateTime Timesheetdate { get; set; }
public string Email { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }

推荐答案

检查ManageTimeSheetsModel是否有Timesheetdate

Check your ManageTimeSheetsModel if it has Timesheetdate

这篇关于根据此代码，我得到“无效的对象名称't​​imesheetdate'。”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！