MSSQL-Stored Procedure return value

1. No external parameters are used in the stored procedure.

Stored procedures:

SET ansi_nulls ongoset quoted_identifier ongo--=============================================--Author:HF_ ultrastrong--Create date:2015 July 19 22:09:24--Description: Determine if there is data and return value using return-================================ =============create PROCEDURE returnvalueasbeginif exists (SELECT * from Tb_category)  return 100else  return- 100END

Code:

<summary>///Click Show Parameters///</summary>///<param name= "sender" ></param>///<param name= "E" ></param>protected void Button1_Click (object sender, EventArgs e) {    SqlConnection con = new SqlConnection ( configurationmanager.appsettings["ConnectionString"]. ToString ());    SqlCommand cmd = new SqlCommand ("returnvalue", con);    Cmd.commandtype = CommandType.StoredProcedure;    The declaration parameter receives the stored procedure return value    SqlParameter returnvalue = cmd. Parameters.Add ("ReturnValue", SqlDbType.Int, 4);    Returnvalue.direction = ParameterDirection.ReturnValue;    Con. Open ();    Cmd. ExecuteNonQuery ();    Con. Close ();    This. Label1.Text = convert.tostring (Returnvalue.value);}

Final effect:

2. Use external parameters in stored procedures.

Stored procedures:

SET ansi_nulls ongoset quoted_identifier ongo--=============================================--Author:HF_ ultrastrong--Create date:2015 July 19 22:09:24--Description: Determine if there is data and return value using return-================================ =============create PROCEDURE returnvalue@10 int,@20 int,@30 intasbeginif exists (SELECT * from Tb_category)  return 100else  Return-100end

Code:

<summary>///Click Show Parameters///</summary>///<param name= "sender" ></param>///<param name= "E" ></param>protected void Button1_Click (object sender, EventArgs e) {    SqlConnection con = new SqlConnection ( configurationmanager.appsettings["ConnectionString"]. ToString ());    SqlCommand cmd = new SqlCommand ("returnvalue", con);    Cmd.commandtype = CommandType.StoredProcedure;    Parameter array    sqlparameter[] para = new sqlparameter[]    {        new SqlParameter ("@10", ten),        new SqlParameter ("@20" ,        new SqlParameter ("@30"), New        SqlParameter ("@Return", SqlDbType.Int)    };    Cmd. Parameters.addrange (para);    Para[para. LENGTH-1]. Direction = ParameterDirection.ReturnValue;    Con. Open ();    Cmd. ExecuteNonQuery ();    Con. Close ();    Object obj = Para[para. LENGTH-1]. Value;    This. Label1.Text = convert.tostring (obj);}

Final effect:

Detailed Explanation: http://www.cnblogs.com/zhangweijia/archive/2013/02/04/2892054.html

MSSQL-Stored Procedure return value