Implementation Code for ASP. NET to obtain the returned values of Stored Procedures

1. First, create a table (UserInfo ).
Main field Id, uname, upass.
2. Create a stored procedure with a returned value Copy codeThe Code is as follows: create proc proc_addUserInfo
@ Uname varchar (50 ),
@ Upass varchar (50 ),
@ Returnc int output
As
Begin
Insert into erp_user (u_name, u_pass) values (@ uname, @ upass)
Set @ Returnc = isnull (@ identity, 0)
End

Here, the returned value is the Id of the added record.
Background code:Copy codeThe Code is as follows: SqlParameter [] para = new SqlParameter []
{
New SqlParameter ("@ uname", "2012 "),
New SqlParameter ("@ upass", "2012 ")
};
String SQL _para = "dbo. proc_addUserInfo ";
CommandType type = CommandType. StoredProcedure;
SQLHelper sqlh = new SQLHelper ();
Int Id = sqlh. ExecuteNoQuery (SQL _para, type, para );

SQLHelper:Copy codeThe Code is as follows: public int ExecuteNoQuery (string SQL, CommandType type, params SqlParameter [] values)
{
Using (SqlCommand cmd = new SqlCommand (SQL, Conn ))
{
Cmd. CommandType = type;
If (values! = Null)
{
Cmd. Parameters. AddRange (values );
}
SqlParameter Retvar = cmd. Parameters. Add ("@ Returnc", SqlDbType. Int );
Retvar. Direction = ParameterDirection. Output;
Int count = cmd. ExecuteNonQuery ();
Return (int) Retvar. Value;
}
}