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
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.