Help in getting the output parameter from sp

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

hi all,
i have storedprocedure who takes one input/output parameter
the sp also return 2 tables.
i m using sqldataadapter.
and read the contents of sp in dataset
in dataset 2 tables are automatically added by the sp which it returns
but how can i get the value of output parameter.

please help me

thanks
Jamil Nawaz
 
Check Managing an @@Identity Crisis by Bill Vaughn at www.betav.com -> Articles -> MSDN

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
hi all,
i have storedprocedure who takes one input/output parameter
the sp also return 2 tables.
i m using sqldataadapter.
and read the contents of sp in dataset
in dataset 2 tables are automatically added by the sp which it returns
but how can i get the value of output parameter.

please help me

thanks
Jamil Nawaz
 
Hi,
In the SQLCommand parameters collection add an SQLParameter with ParameterDirection.Output.
After executing the SP we can retrieve the value using
sqlSelectCommand1.Parameters["@ParamName"].Value
Regards,
Sambathraj
hi all,
i have storedprocedure who takes one input/output parameter
the sp also return 2 tables.
i m using sqldataadapter.
and read the contents of sp in dataset
in dataset 2 tables are automatically added by the sp which it returns
but how can i get the value of output parameter.

please help me

thanks
Jamil Nawaz
 
Back
Top