Login System (ASP.NET C#)
|
06-05-2010, 04:49 PM
Post: #1
|
|||
|
|||
Login System (ASP.NET C#)
i have been trying to create a login system for a small project. The username and password are stored in MS SQL i can log in but the session will remain as not logged in any ideas why guys ?
protected void BtnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid) { SqlCommand command = new SqlCommand("SELECT * FROM Member WHERE MemberUsername = @Username AND MemberPassword = @Password", c.connection); c.connection.Open(); command.Parameters.AddWithValue("@Username", TxtUsername.Text); command.Parameters.AddWithValue("@Password", TxtPassword.Text); SqlDataReader DataReader = command.ExecuteReader(); while (DataReader.Read()) { if (DataReader["MemberRoleID"].ToString() == "1") { Session["userid"] = TxtUsername.Text; LblWelcome.Text = "Welcome: " + (Session["userid"]); Response.Redirect("Register.aspx"); BtnSubmit.Enabled = false; } else if (DataReader["MemberRoleID"].ToString() == "2") { Session["userid"] = TxtUsername.Text; LblWelcome.Text = "Welcome: " + (Session["userid"]); Response.Redirect("PostComments.aspx"); BtnSubmit.Enabled = false; } } c.connection.Close(); } } Web Design Web Design Melbourne | SEO Company |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
Login System (ASP.NET C#) - dreamcon - 06-05-2010 04:49 PM
RE: Login System (ASP.NET C#) - dianna - 08-12-2011, 08:33 PM
RE: Login System (ASP.NET C#) - netshet - 08-13-2011, 07:29 PM
RE: Login System (ASP.NET C#) - hairtransplant - 01-18-2012, 08:08 PM
|
User(s) browsing this thread: 1 Guest(s)