sql server output parameters ado.net

Question

cmd.Parameters.Add(New SqlParameter("LossID", SqlDbType.Int).Direction = ParameterDirection.Output)
.....
Dim LossID as integer

lossID = cmd.Parameters("@LossID").Value

When I add my output parameter to my command object, I am receiving a

The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.

How do I correctly place my return value into the lossID integer? thank you very much

Your definition uses LossID and when you try to access your parameters collection, you use @LossID - I think you should consistently use the notation with the leading at (@) sign. — marc_s
– marc_s, Commented Apr 28, 2011 at 15:56

Daniel Renshaw · Accepted Answer · 2011-04-28 14:58:38Z

2

You need to separate the assignment of the Direction property from the adding of the parameter to the parameters collection.

param = New SqlParameter("LossID", SqlDbType.Int)
param.Direction = ParameterDirection.Output
cmd.Parameters.Add(param)

answered Apr 28, 2011 at 14:58

Daniel Renshaw

34.3k8 gold badges78 silver badges95 bronze badges

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

2 Comments

gh9 Over a year ago

Seems wierd, why cant i one line it?

Daniel Renshaw Over a year ago

Because the type of New SqlParameter("LossID", SqlDbType.Int).Direction = ParameterDirection.Output is a Boolean, not a SqlParameter while cmd.Parameters.Add(.) needs to be given an object of type SqlParameter.

Collectives™ on Stack Overflow

sql server output parameters ado.net

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related