Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/1/30 1:30:27 一个使用存储过程实现的用户登录功能(含代码)_[Asp.Net教程]
public SqlDataReader GetUserLoginByProc(string sUserName,string sPassword) { ///创建链接 SqlConnection myConnection = new SqlConnection( ConfigurationManager.ConnectionStrings["数据库连接字符"].ConnectionString);
///创建Command SqlCommand myCommand = new SqlCommand("Pr_GetUserLogin",myConnection); ///设置为执行存储过程 myCommand.CommandType = CommandType.StoredProcedure;
///添加存储过程的参数 SqlParameter pUserName = new SqlParameter("@UserName",SqlDbType.VarChar,32); pUserName.Value = sUserName; myCommand.Parameters.Add(pUserName);
SqlParameter pPassword = new SqlParameter("@Password",SqlDbType.VarChar,255); pPassword.Value = sPassword; myCommand.Parameters.Add(pPassword);
///定义DataReader SqlDataReader dr = null; try { ///打开链接 myConnection.Open(); ///读取数据 dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); } catch(SqlException ex) { ///抛出异常 throw new Exception(ex.Message,ex); } ///返回DataReader return dr; }
CREATE PROCEDURE Pr_GetUserLogin( @UserName varchar(32), @Password varchar(255))
AS SELECT UserIDFROM UsersWHERE UserName = @UserName AND Password = @Password
GO
赞