using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; using System.Data; public partial class Login : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString); con.Open(); if (true) { SqlCommand level = new SqlCommand("select AccessLevel, Password from TableSecurity where EmailAddress = @EmailAddress AND Password = @Password", con); level.Parameters.Add(new SqlParameter("EmailAddress", TextBoxEA.Text)); level.Parameters.Add(new SqlParameter("Password", TextBoxPW.Text)); SqlDataReader reader = level.ExecuteReader(); DataTable dt1 = new DataTable(); dt1.Load(reader); foreach (DataRow dr1 in dt1.Rows) { int returnedLevel = Convert.ToInt32(dr1[0].ToString()); if (returnedLevel == 1) { Response.Redirect("FormAPublic.aspx"); } else if (returnedLevel == 2) { Response.Redirect("FormCPrivateNon.aspx"); } else if (returnedLevel == 3) { Response.Redirect("FormDPrivateFor.aspx"); } else if (returnedLevel == 7) { Response.Redirect("CEOPage.aspx"); } else if (returnedLevel == 8) { Response.Redirect("DBPage.aspx"); } } } con.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)