Adding SqlParameter

Question

I am re-writing a login process I wrote in Console to a web based application and keep getting hung up when I add the SqlParamater. For some reason it doesn't recogize FirstName and gives the error "The FirstName does not exist in current context".

How can I solve this?

//set the command object so it knows to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;

//Doesn't understand line under....
cmd.Parameters.Add(new SqlParameter("@FirstName", FirstName)); 
parmReturnValue = cmd.Parameters.AddWithValue("@UserId", SqlDbType.Int);
parmReturnValue.Direction = ParameterDirection.ReturnValue;

Oded · Accepted Answer · 2011-02-26 20:41:39Z

1

The variable FirstName that you are passing to the SqlParameter constructor is not recognized - where is it defined?

You need to ensure that this variable is accessible in the scope of the code you posted.

Contrary to the answer by @gov, this has nothing to do with SQL, since you are getting this as a compilation error.

answered Feb 26, 2011 at 20:41

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jpavlov Over a year ago

Correct, I missed the elphant in the room. My FirstName is now txtUserName. Thanks for pointing that out.

kobe · Accepted Answer · 2011-02-26 20:38:52Z

1

Please check in the database what name you gave in the stored procedure

@FirstName"

the above should match the argument in stored procedure

answered Feb 26, 2011 at 20:38

kobe

15.9k15 gold badges67 silver badges93 bronze badges

Collectives™ on Stack Overflow

Adding SqlParameter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related