如何解决这个异常？

公开名单< employee> AddEmployee（）

{

List< employee> employee = new List< employee>（）;

Employee objemp = new Employee（）;

try

{

using（SqlConnection con = new SqlConnection（cs））

{

SqlCommand cmd = new SqlCommand（sp_insert_employee_tblEmployee，con）;

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue（@ Name，objemp.Name）;

cmd.Parameters.AddWithValue（@ Gender ，objemp.Gender）;

cmd.Parameters.AddWithValue（@ City，objemp.City）;

cmd.Parameters.AddWithValue（@ DateofJoining， objemp.Dateofjoining.ToShortTimeString（））;

con.Open（）;

cmd.ExecuteNonQuery（）;



}

employee.Add（objemp）;

}

catch（例外情况）

{

throw;

}

返回员工;



}

}



这个方法有什么问题请有人帮帮我



得到以下异常。





过程或函数'sp_insert_employee_tblEmployee'需要参数'@Name'，这是未提供的。



程序是 -



创建程序[dbo]。[sp_insert_employee_tblEmployee]

@Name varchar（50）NULL，

@Gender varchar（50）NULL，

@City Varchar（50）NULL，

@Dateofjoining datetime

as

begin

插入tblEmployee值（@ Name，@ Gender，@ City，@ Dateofjoining）

结束

public List<employee> AddEmployee()
{
List<employee> employee = new List<employee>();
Employee objemp = new Employee();
try
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("sp_insert_employee_tblEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", objemp.Name);
cmd.Parameters.AddWithValue("@Gender", objemp.Gender);
cmd.Parameters.AddWithValue("@City", objemp.City);
cmd.Parameters.AddWithValue("@DateofJoining", objemp.Dateofjoining.ToShortTimeString());
con.Open();
cmd.ExecuteNonQuery();

}
employee.Add(objemp);
}
catch(Exception ex)
{
throw;
}
return employee;

}
}

What is wrong with this method please can anybody help me

getting following exception.


Procedure or function 'sp_insert_employee_tblEmployee' expects parameter '@Name', which was not supplied.

Procedure is --

Create procedure [dbo].[sp_insert_employee_tblEmployee]
@Name varchar(50) NULL,
@Gender varchar(50) NULL,
@City Varchar (50) NULL,
@Dateofjoining datetime
as
begin
Insert into tblEmployee values(@Name,@Gender,@City,@Dateofjoining)
End