Help in getting the output parameter from sp

[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

 

[W.G. Ryan eMVP]

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

 

[Sambathraj]

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