-- --創建存儲過程


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