我从网上找了很多都不行,希望朋友给一个,asp登陆的存储过程,和用asp调用这个存储过程的代码,谢谢!!你们asp教程里没有关于怎么调用存储过程的例子吗？ SQL code: Create PROCEDURE User_Login @username varchar(50), @password varchar(50), @userreturn BIT OUTPUT AS DECLARE @strPwd NVARCHAR(20) select @strPwd=***_pass_word from fs_mf_*** where ***_name=@username IF @password=@strPwd SET @userreturn=1 ELSE SET @userreturn=0 GO
非SQL内容,去ASP版问. C# code: string UserName = txtUserName.Text.ToString(); string PassWord = txtPassWord.Text.ToString(); PassWord = FormsAuthentication.HashPasswordForStoringInConfigFile(PassWord, "md5").ToLower().Substring(8, 16); SqlParameter[] par = new SqlParameter[3]; par[0] = new SqlParameter("@username", SqlDbType.VarChar, 50); par[0].Value = UserName; par[1] = new SqlParameter("@password",SqlDbType.VarChar,50); par[1].Value = PassWord; par[2] = new SqlParameter("@userreturn", SqlDbType.Int, 4)
