i can handle a store procedure which returns one output parameter using ExecuteScalar()
but wot if my store procedure returns more than one parameter
then how can i handle it. any advice Adapost ?
dnanetwork
18
Practically a Master Poster
Banned
Recommended Answers
Jump to Posti think by following below code, we can retrieve value of more than one parameter. The code is for one parameter.
SqlParameter returnValueParam = cmd.Parameters.Add(@return,SqldbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
int returnValue = (int) returnValueParam.Value;
All 2 Replies
rohand
1
Posting Whiz in Training
i think by following below code, we can retrieve value of more than one parameter. The code is for one parameter.
SqlParameter returnValueParam = cmd.Parameters.Add(@return,SqldbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
int returnValue = (int) returnValueParam.Value;
dnanetwork
18
Practically a Master Poster
Banned
thnx rohand...i'll check and let u know...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.