登录屏幕-密码 [英] Login Screen - Password

问题描述

请帮助.如何最好地将 VB ASP (Visual Studio 2005)login.aspx连接到服务器\\ SERVER01 \上的我的 MSSQL 2005数据库，以验证用户名和密码并对其进行验证是一个有效用户(在用户表中)，然后设置一个环境变量，我可以将该环境变量发送给我执行的每个存储过程(作为参数之一)，直到他/她注销(在这种情况下，环境变量必须为重置为NULL).

我真的需要你们的帮助.我希望这不是一个愚蠢的问题！
谢谢，MAC

Please help. How best to connect my VB ASP (Visual Studio 2005) login.aspx to my MSSQL 2005 database on the server \\SERVER01\ to validate the userid and password and IF it is a valid user (in the users table) , then set an environment variable that I can send to every Stored Procedure I execute [as one of the parameters], until he/she logs out (in which case it the environment variable must be reset to NULL).

I really need your help guys. I hope this is not a dumb question!!!

Thanks, MAC

推荐答案

看看:
创建安全的PHP登录脚本 [ ^ ]
PHP表单验证 [ PHP注册表格 [

Have a look:
Creating a Secure PHP Login Script[^]
PHP form validation[^]
PHP registration form[^]

http://www.pcreview.co.uk/forums/bc30002- type-directoryentry-not-defined-t1341751.html [ ^ ]

请在sql server中创建存储过程以进行登录.

将登录页面的用户名和密码传递到此存储过程以检入表.

如果记录存在，则设置环境变量，否则将其重置为null.

Please create a stored procedure in sql server for login.

Pass username and password from login page to this stored procedure to check in the table.

If record exists, than set environment variable else reset to null.

这篇关于登录屏幕-密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！