1. First, we will establish a table (UserInfo).
Primary field ID, uname, upass.
2. Create a stored procedure with a return value
Copy Code code 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
Return value here I get the ID of the add record.
Background code:
Copy Code code 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 Code code 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;
}
}
