存储过程调用

-- --创建存储过程


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);
    }