用户登录代码实现

用户登录代码实现 protected void btn_login_Click(object sender, EventArgs e) { string strcmd = ""; int i; DataAcess mydataAcess = new DataAcess( ) if (txtUsername.Text.Trim() != "" && txtPassword.Text.Trim() != "") { if (DropDownList1.Text == "管理员") { strcmd = "select count(*) from admin where 用户名='" + txtUsername.Text + "' and 密码='" + txtPassword.Text + "'"; temp = 1; } if (DropDownList1.Text == "教师") { strcmd = "select count(*) from teacher where 教师编号='" + txtUsername.Text + "' and 密码='" + txtPassword.Text + "'"; temp = 2; } if (DropDownList1.Text == "学生") { strcmd = "select count(*) from student where 学号='" + txtUsername.Text + "' and 密码='" + txtPassword.Text + "'"; temp = 3; } i = mydataAcess.ExecuteScalar(strcmd); if (i == 1) { Session["Username"] = txtUsername.Text.ToString(); if (temp == 1) Response.Redirect("admin//stuadmin.aspx"); if (temp == 2) Response.Redirect("teacher//index.aspx"); if (temp == 3) Response.Redirect("student//index.aspx"); } else Response.Write("") } else { Response.Write(""); txtUsername.Text = ""; txtPassword.Text = ""; } } using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace login { public partial class Form1 : Form { public Form1() { InitializeComponent(); } protected void button1_Click(object sender, EventArgs e) { SqlConnection sqlcon = new SqlConnection("Data Source=20101211-1746\\SQLEXPRESS;Initial Catalog=recruitsystem;Integrated Security=True "); if (txtNum.Text.Length == 0) Information.Text = "请输入用户名～"; else { if (txtPwd.Text.Length == 0) Information.Text = "请输入密码～"; else if (txtNum.Text == "Admin" && txtPwd.Text == "Admin") { Information.Text = "用户:" + txtNum.Text + "登录成功～"; } else Information.Text = "用户不存在或密码不正确～"; } } private void Form1_Load(object sender, EventArgs e) { } private void btnconcel_Click(object sender, EventArgs e) { } } }