为过程或函数 BanZhu_GetByBBSUserID 指定了过多的参数。

/// <summary>
/// 根据员工号查询是否是版主
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public bool GetByBBSUserID(int UserID,int BanKuaiID)
{
SqlParameter[] parm=new SqlParameter[]
{
new SqlParameter("@BanKuaiID",BanKuaiID),
new SqlParameter("@BBSUserID", UserID)
};
DataTable dt = DBHelper.GetDataSet("BanZhu_GetByBBSUserID", parm);
return dt.Rows.Count > 0 ? true : false;
}


public static DataTable GetDataSet(string procSql, params SqlParameter[] values)
{
try
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(procSql, Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(values);
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(ds);
return ds.Tables[0];
}
catch//为过程或函数 BanZhu_GetByBBSUserID 指定了过多的参数。 {
return null;
}
}


存储过程:
create proc BanZhu_GetByBBSUserID
(
@BBSUserID int,
@BanKuaiID int
)
as
begin
select * from BanZhu where BBSUser_ID=@BBSUserID and BanKuai_ID=@BanKuaiID
end
go

谁知道我上面哪里错了啊,找了半天了,找不出来,在网上查的说把cmd.parmat.clean()就可以,我试了也是不行