返回首页

嗨,在我的表只有两列有一个用户名和密码..
我想,以验证这一点,如果用户名和密码是正确的,那么它wil重定向页Welcome.aspx或无效的登录名和密码,..
可任何人的帮助......??

回答

评论会员:游客 时间:2012/02/07
ParwejAhamad:使用表单验证,并给有Welcome.aspx作为默认页。谷歌在ASP.NET窗体身份验证,你会发现很多文章搜索
C#中

protected void ValidateUserInfo(string user, string pass)

{

  

    SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");

    string sql = "SELECT * FROM TableName WHERE UserID = @username AND Password = @password";

    SqlCommand cmd = new SqlCommand(sql,connection);

    cmd.Parameters.AddWithValue("@username", user);

    cmd.Parameters.AddWithValue("@password", pass);

    connection.Open();

 

    DataTable dt = new DataTable();

    SqlDataAdapter ad = new SqlDataAdapter(cmd);

    ad.Fill(dt);

    if (dt.Rows.Count > 0) { //check if the query returns any data

        //Valid Username and Password

        Response.Redirect("Default.aspx");

    }

    else

    {

        Response.Write("INVALID Username and Password, Try Again!");

    }

    connection.Close();   

}

protected void Button1_Click(object sender, EventArgs e)

{

  ValidateUserInfo(TextUserName.Text.Trim(), TextPassword.Text.Trim());

}

 


VB.NET

{C}
就是这么简单!编码快乐!
评论会员:游客 时间:2012/02/07
Monjurul哈比卜:尝试以下操作:imgsrc={A}{A2}{A4纸}{A5的}{A6的}
ManavGuru
评论会员:游客 时间:2012/02/07
您好,您可以此方法添加到您的登录点击按钮事件codeprespanclass="code-keyword"public/spanspanclass="code-keyword"void/spanlogin(){spanclass="code-keyword"string/spanstrLoginId;spanclass="code-keyword"string/spanstrPassword;DataSetoDs=spanclass="code-keyword"null/span;spanclass="code-keyword"bool/spanIsRemember=chkRememberMe.Checked; spanclass="code-comment"///spanspanclass="code-comment"thisisclassfilewhereyouwillbewriteyourcodeforgettheinformationtodatabase/spanCityBusinessLogics.AdminLogicsoAdmin=spanclass="code-keyword"new/spanCityBusinessLogics.AdminLogics();strLoginId=txtUsername.Text.Trim();strPassword=txtPassword.Text.Trim();HttpCookieOnlineCookie=spanclass="code-keyword"new/spanHttpCookie(spanclass="code-string""/spanspanclass="code-string"OnlineCookie"/span); spanclass="code-keyword"if/span(Page.IsValid){spanclass="code-keyword"try/span{oDs=oAdmin.ValidateAdminLogin(strLoginId,strPassword);spanclass="code-keyword"if/span(oDs.Tables[spanclass="code-digit"0/span].Rows.Count<=spanclass="code-digit"0/span){lblMessage.Text=spanclass="code-string""/spanspanclass="code-string"WrongLoginIdorPassword!!"/span;lblMessage.Visible=spanclass="code-keyword"true/span;}spanclass="code-keyword"else/spanspanclass="code-keyword"if/span(IsRemember){spanclass="code-keyword"string/spanEnUserName,EnPwd;EnUserName=oAdmin.base64Encode(strLoginId);EnPwd=oAdmin.base64Encode(strPassword); OnlineCookie.Values.Add(spanclass="code-string""/spanspanclass="code-string"UserName"/span,EnUserName);OnlineCookie.Values.Add(spanclass="code-string""/spanspanclass="code-string"Password"/span,EnPwd); Response.Cookies.Add(OnlineCookie);OnlineCookie.Expires=DateTime.Now.AddDays(spanclass="code-digit"15/span); Session[spanclass="code-string""/spanspanclass="code-string"Admin"/span]=strLoginId;spanclass="code-keyword"if/span(Session[spanclass="code-string""/spanspanclass="code-string"Admin"/span].ToString()==spanclass="code-string""/spanspanclass="code-string"admin"/span)Response.Redirect(spanclass="code-string""/spanspanclass="code-string"AdminChangePassword.aspx"/span);spanclass="code-keyword"else/spanResponse.Redirect(spanclass="code-string""/spanspanclass="code-string"RoleTask.aspx"/span); }spanclass="code-keyword"else/span{spanclass="code-comment"///spanspanclass="code-comment"OnlineCookie.Values.Add("UserName",string.Empty);/spanspanclass="code-comment"///spanspanclass="code-comment"OnlineCookie.Values.Add("Password",string.Empty);/spanspanclass="code-comment"///spanspanclass="code-comment"OnlineCookie.Values.Add("Roles",string.Empty);/spanspanclass="code-comment"///spanspanclass="code-comment"Response.Cookies.Add(OnlineCookie);/spanspanclass="code-comment"///spanspanclass="code-comment"OnlineCookie.Expires=DateTime.Now.AddMinutes(5);/spanSession[spanclass="code-string""/spanspanclass="code-string"Admin"/span]=strLoginId;spanclass="code-comment"///spanspanclass="code-comment"Session["Roles"]=oDs.Tables[0].Rows[0]["RoleIds"].ToString();/spanspanclass="code-keyword"if/span(Session[spanclass="code-string""/spanspanclass="code-string"Admin"/span].ToString()==spanclass="code-string""/spanspanclass="code-string"admin"/span)Response.Redirect(spanclass="code-string""/spanspanclass="code-string"AdminChangePassword.aspx"/span);spanclass="code-keyword"else/spanResponse.Redirect(spanclass="code-string""/spanspanclass="code-string"RoleTask.aspx"/span);} }spanclass="code-keyword"catch/span{lblMessage.Text=spanclass="code-string""/spanspanclass="code-string"Loginfailed."/span;lblMessage.Visible=spanclass="code-keyword"true/span;}}/pre/code我希望,这将是为你乐于助人谢谢
Vasim889
评论会员:{体C3} 时间:2012/02/07