存储过程
- CREATE PROCEDURE [dbo].[Login_Test]
- (
- @UserName nvarchar(50),
- @flag int out
- )
- AS
- if exists(SELECT * FROM Admin WHERE UserName =@UserName)
- begin
- set @flag=11;
- end
- else
- begin
- set @flag=10;
- end
- GO
执行方法
- /// <summary>
- /// 带输出参数的存储过程原型
- /// </summary>
- /// <param name="sUserName"></param>
- /// <returns></returns>
- public int testoutput(string sUserName)
- {
- SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString());
- SqlCommand scd = new SqlCommand();
- scd.Connection = myConnection;
- scd.CommandText = "Login_Test";
- scd.CommandType = CommandType.StoredProcedure;
- //增加输入参数
- SqlParameter paramin = scd.CreateParameter();
- paramin.ParameterName = "@UserName";
- paramin.DbType = DbType.String;
- paramin.Size = 50;
- paramin.Value = sUserName;
- //增加输出参数，多了个Direction少了个Value
- SqlParameter paramout = scd.CreateParameter();
- paramout.ParameterName = "@flag";
- paramout.DbType = DbType.Int32;
- paramout.Size = 4;
- paramout.Direction = ParameterDirection.Output;
- //别忘了加入
- scd.Parameters.Add(paramin);
- scd.Parameters.Add(paramout);
- myConnection.Open();
- scd.ExecuteNonQuery();
- myConnection.Close();
- //返回
- return (int)paramout.Value;
- }