By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,888 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

SQLHelper Stored Procedure Output Parameter

P: n/a
Hi, All
How to get the output parameter's value when you use the SQLHelper
(Microsoft Data Access Block)?

When I try to access my ourput parm I got the following error.

System.NullReferenceException: Object reference not set to an instance
of an object.

I thought it is because there is a statement cmd.Parameters.Clear() in
ExecuteNonQuery function, but even I comment this parameter clear
statement, it still caught the same error.

Before ExecuteNonQuery return, The output value is still in the output
parm. but when return to SqlHelper.ExecuteNonQuery(), the output
parameter value got lost while the vlaue of input parameter is still
there.

Did I miss something? Or SQLHelper can not return output parameter?

Help Please

---------------------------------------------------------------------------------------------
public string TestOutput(int pFlag){
SqlParameter[] parm = new SqlParameter[3];

parm[0] = new SqlParameter("@flag", SqlDbType.Int,4);
parm[0].Value = pFlag;
parm[1] = new SqlParameter("@result_txt", SqlDbType.VarChar,32);
parm[1].Direction = ParameterDirection.InputOutput;
parm[2] = new SqlParameter("@result_txt", SqlDbType.Int,4);
parm[2].Direction = ParameterDirection.InputOutput;
// parm[2].Direction = ParameterDirection.Output;

SqlHelper.ExecuteNonQuery(ConnectionString, "UDSP_OUTPUT_TEST",
parm);

return parm[1].Value.ToString();
}

--------------------------------------------------------------------------------------------

CREATE PROCEDURE UDSP_OUTPUT_TEST
@flag int,
@result_txt varchar (32) output,
@result_code int output
AS
begin

set nocount on
if @flag=1
begin
select @result_txt = 'ERROR RETURNED FROM SP'
select @result_code = -1
return
end
else
begin
select @result_txt = 'SUCCEED RETURNED FROM SP'
select @result_code = 0

end

set nocount off

end

May 30 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.