接触T-SQL存储过程

数据库Temp中有一表:
Admin结构如下：
AdminName varchar(10)
AdminPass  varchar(15)
内容:
AdminName   admin
AdminPass    admin
新建存储过程：
create procedure Login
@AdminN varchar(10),
@AdminP varchar(15),
@Out int output
as
--定义一个临时存储密码的变量
declare @Pwd varchar(15)
begin
  select @Pwd=adminPass where AdminName=@AdminN
  if @AdminP=@Pwd 
  begin
     set @Out=1
 end
 else
    set @Out=0
end
go
c#文件调用如下：

 SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=Temp");
        SqlCommand sqlcmd = new SqlCommand();
        sqlcmd.Connection = sqlcon;
        sqlcmd.CommandType = CommandType.StoredProcedure;
        sqlcmd.CommandText = "LuckyStarLogin";
        sqlcmd.Parameters.Add("@AdminN", SqlDbType.VarChar).Value = "admin";
        sqlcmd.Parameters.Add("@AdminP", SqlDbType.VarChar).Value = "admin";
        SqlParameter sp = sqlcmd.Parameters.Add("@Out", SqlDbType.Int);
        sp.Direction = ParameterDirection.Output;
        sqlcon.Open();

        sqlcmd.ExecuteNonQuery();
        if (Convert.ToInt32(sp.Value )== 1)
        {
            Response.Write("登陆成功");
        }
        else
        {
            Response.Write("登陆失败");
        }