public void Authenticate(string Username,string Password) { string Encryptpassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtpassword.Text,SHA1); string cs = ConfigurationManager.ConnectionStrings [DBCS]。ConnectionString; 使用(SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand(spAuthenticateUsers,con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@ Username,txtuname.Text); cmd.Parameters.AddWithValue(@ Password,Encryptpassword); con.Open(); SqlDataReader dr = cmd.ExecuteReader (); while(dr.Read()) { int retryattempts = Convert.ToInt32(dr [retryattempts]) ; // if(Convert.ToBoolean(dr [Accountlocked])) { Label1.Text =帐户已锁定请联系管理员; } 否则if(retryattempts> 0) { int Attemptsleft =(4 - retryattempts); Label1.Text =无效的用户名或密码+ Attemptsleft.ToString()+Attemptsleft; } else if(Convert.ToBoolean(dr [Authenticated])) { FormsAuthentication.RedirectFromLoginPage(txtuname.Text,CheckBox1。已检查); } 其他 { Label1.Text =无效的用户名/密码; } } } //此行我得到异常是什么意思? int retryattempts = Convert.ToInt32(dr [retryattempts]); 请提前帮助我谢谢 和stroed程序是 创建程序sptblUserAuthentication @Username nvarchar(50) , @Password nvarchar(50) As 开始 声明@Accountlocked int 声明@Count int 声明@Retrycount位 结束 - 声明已完成 - 选择@Accountlocked =从tblUsers中锁定其中用户名= @用户名 if(@Accountlocked = 1) 开始 选择1作为Accountlocked,0作为RetryAttempts,0作为Authenticated 结束 否则 开始 - 检查用户名和密码是否匹配 - 选择COUNT(用户名)来自tblUsers用户名= @用户名和密码= @密码 - 如果找到匹配 - if(@Count = 1) 开始 - 重置值 - 更新tblUsers设置RetryAttempts = 0其中Username = @ Username 选择0作为RetryAttempts,1 as Authenticated,0 as Accountlocked 结束 否则 开始 - 如果找不到匹配 - 选择@Retrycount = IsNull(RetryAttempts,0)来自 tblUsers其中用户名= @用户名 设置@ Retrycount = @Retrycount + 1 if(@Retrycount< = 3) 开始 - 如果重试尝试没有完成 - 更新tblUsers设置RetryAttempts = @Retrycount Where Username = @用户名 选择0作为帐户锁定,0作为已验证,@ Retrycount作为RetryAttempts 结束 否则 开始 - 如果重试尝试没有完成 - 更新tblUsers设置RetryAttempts = @ Retrycount,Islocked = 1,LockDatetime = GETDATE()其中Username = @ Username 选择1作为账户锁定,0作为认证,0作为RetryAttempts 结束 结束 结束
public void Authenticate(string Username, string Password) { string Encryptpassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtpassword.Text, "SHA1"); string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using(SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spAuthenticateUsers",con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Username",txtuname.Text); cmd.Parameters.AddWithValue("@Password", Encryptpassword); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { int retryattempts = Convert.ToInt32(dr["retryattempts"]); // if(Convert.ToBoolean(dr["Accountlocked"])) { Label1.Text = "Account locked Please contact Administrator"; } else if (retryattempts > 0) { int Attemptsleft = (4 - retryattempts); Label1.Text = "Invalid Username or Password" + Attemptsleft.ToString() + "Attemptsleft"; } else if (Convert.ToBoolean(dr["Authenticated"])) { FormsAuthentication.RedirectFromLoginPage(txtuname.Text, CheckBox1.Checked); } else { Label1.Text = "invalid Username/Password"; } } } // this line iam getting the exception what does it mean? int retryattempts = Convert.ToInt32(dr["retryattempts"]); Help me out thanks in advance and the stroed procedure is Create Procedure sptblUserAuthentication @Username nvarchar(50), @Password nvarchar(50) As Begin Declare @Accountlocked int Declare @Count int Declare @Retrycount bit End -- Declaration is finished-- Select @Accountlocked = Islocked from tblUsers Where Username=@Username if(@Accountlocked = 1) Begin Select 1 as Accountlocked,0 as RetryAttempts,0 as Authenticated End Else Begin --Check if the username and password is match-- Select COUNT(Username) from tblUsers Where Username=@Username and Password=@Password --if match found-- if(@Count = 1) Begin --Reset values -- Update tblUsers set RetryAttempts=0 Where Username=@Username Select 0 as RetryAttempts,1 as Authenticated,0 as Accountlocked End Else Begin --if match not found-- Select @Retrycount = IsNull(RetryAttempts,0) from tblUsers Where Username=@Username Set @Retrycount = @Retrycount + 1 if(@Retrycount <= 3) Begin --if retry attempts are not completed-- Update tblUsers Set RetryAttempts = @Retrycount Where Username=@Username Select 0 as Accountlocked,0 as Authenticated,@Retrycount as RetryAttempts End Else Begin --if retry attempts are not completed-- Update tblUsers set RetryAttempts=@Retrycount ,Islocked=1,LockDatetime=GETDATE() Where Username=@Username Select 1 as Accountlocked,0 as Authenticated,0 as RetryAttempts End End End
推荐答案您好, System.IndexOutOfRangeException异常表示您正在访问具有无效索引的数组或容器。也就是索引指的是一个不存在的项目。在您的代码中, Hi, The System.IndexOutOfRangeException exception indicates that you are accessing an array or container with an invalid index. That is the index refers to an item that does not exist. in your code, int retryattempts = Convert.ToInt32(dr["retryattempts"]);
检查该索引的dr是否存在,否则您将获得此异常。 另请参阅: http ://msdn.microsoft/en-us/library/system.indexoutofrangeexception%28v=vs.110%29.aspx [ ^ ] 问候, Praneet Nadkar
Check that dr for that index exists, otherwise you wil get this exception. Also please refer to this : msdn.microsoft/en-us/library/system.indexoutofrangeexception%28v=vs.110%29.aspx[^] Regards, Praneet Nadkar
更多推荐
如何解决System.IndexOutOfRangeException:retryattempts?这是什么意思?
发布评论