存储过程调用

-- --创建存储过程


create   procedure  login( @user   varchar ( 50 ), @pwd   varchar ( 50 ) , @blnReturn   int  output)
as
Declare   @_user   varchar ( 50 ), @_pwd   varchar ( 50 )

begin
   
      select    @_pwd = [ pwd ]    from  tb_Admin  where   [ user ] = @_user
  if   @_pwd = @pwd
         
   begin  
 
    
      set     @blnReturn =   1

     
    end  
    else
     set   @blnReturn = 0

end




-- --查询分析器中调试存储过程
declare   @return   int

exec  login   ' hnlyw ' ,  ' 7FEF6171469E80D32C0559F88B377245 ' ,  @return  output
    print   @return

 

 

Code
 protected int getLogin(string _username, string _pwd)
    {
        SqlConnection con = new SqlConnection("server=20090727-1216;uid=sa;pwd=sa;database=hnlyw");

        SqlCommand com = new SqlCommand();
        com.Connection = con;
        com.CommandText = "login";
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.Add("@user", SqlDbType.VarChar, 50);
        com.Parameters["@user"].Value = _username;
        com.Parameters.Add("@pwd", SqlDbType.VarChar, 50);
        com.Parameters["@pwd"].Value=_pwd;
        com.Parameters.Add("@blnReturn",SqlDbType.Int);
        com.Parameters["@blnReturn"].Direction = ParameterDirection.Output;
        con.Open();
        com.ExecuteNonQuery();
        com.Dispose();
        con.Close();
        return Convert.ToInt32(com.Parameters["@blnReturn"].Value);
    }

 

转载于:https://my.oschina.net/u/926126/blog/302369