An SqlParameter with ParameterName '@result' is not contained by this SqlParameterCollection

Question

Hi, when run my code, I got the error, and I checked the storeprocedure which runs good.  Please advise.

txt = TextBox1.Text;
            this.conn.Open();
            SqlCommand cmd = new SqlCommand("VerifyEmployeeID", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("EmployeeID", SqlDbType.Int, 50).Value = txt.Trim();
            cmd.Parameters.Add("result", SqlDbType.Int, 50).Direction = ParameterDirection.Output;
            cmd.ExecuteNonQuery();
            int count = Convert.ToInt32(cmd.Parameters["@result"].Value);
            if (count > 0)
            {
                Label1.Visible = true;
            }
            else
            {
                Response.Write("good");
            }

ALTER PROCEDURE [dbo].[VerifyEmployeeID]
	
	@EmployeeID int,
	@result int=50 output
AS
BEGIN
	if exists (select EmpID from dbMarketing.ui.tblNationalTESAdjunt
	            where EmpID = @EmployeeID) or exists
	            (select EmpIDGoal from dbMarketing.ui.tblNationalTESGOAL
	           where  EmpIDGoal = @EmployeeID  )
	       set @result = 1
	       else
	       set @result = 0     
END

Answer 1

txt = TextBox1.Text;
            this.conn.Open();
            SqlCommand cmd = new SqlCommand("VerifyEmployeeID", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@EmployeeID", SqlDbType.Int, 50).Value = txt.Trim();
            cmd.Parameters.Add("@result", SqlDbType.Int, 50).Direction = ParameterDirection.Output;
            cmd.ExecuteNonQuery();
            int count = Convert.ToInt32(cmd.Parameters["@result"].Value);
            if (count > 0)
            {
                Label1.Visible = true;
            }
            else
            {
                Response.Write("good");
            }

You declared your parameter as Result and then tried to access it as @Result

---

Chuck

Answer 2

hi,

doesn't it need to be like this:

 int count = Convert.ToInt32(cmd.Parameters["result"].Value);

---

Regards, Nico

Answer 3

You should be consistent. If you added parameters without @ in front, use these names. But I suggest to add them with the @ sign, e.g.

cmd.Parameters.Add("@EmployeeID", SqlDbType.Int, 50).Value = txt.Trim();
            cmd.Parameters.Add("@result", SqlDbType.Int, 50).Direction = ParameterDirection.Output;

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 4

My bad. typo