科奥制冷网站

public partial class Manages_ManageLogins : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { try { if (TextBox1.Text == "" || TextBox2.Text == "") { this.Page.RegisterStartupScript("ss", "<script>alert('用户名称和密码信息不能为空!')</script>"); return; } else { string num = this.TextBox3.Text.Trim(); if (Session["ValidNums"].ToString() == num.ToUpper()) { // 连接数据库 string Straddcon = Server.MapPath("../kocooldb.mdb"); OleDbConnection sqlcon = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + Straddcon); sqlcon.Open(); string strselect = "select * from tb_user where username='" + TextBox1.Text.Trim() + "'"; OleDbDataAdapter adsas = new OleDbDataAdapter(strselect, sqlcon); DataSet addss = new DataSet(); adsas.Fill(addss); if (addss.Tables[0].Rows.Count > 0) { //SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString); //sqlcon.Open(); string strselect1 = "select * from tb_user where username='" + TextBox1.Text.Trim() + "' and pwd='" + TextBox2.Text.Trim() + "'"; OleDbCommand sqlcmd1 = new OleDbCommand(strselect1, sqlcon); OleDbDataReader dr1 = sqlcmd1.ExecuteReader(); if (dr1.Read()) { //Request["userid"] = dr1["id"].ToString(); Session["username"] = TextBox1.Text; Response.Redirect("Manages.aspx"); } else { this.Page.RegisterStartupScript("ss", "<script>alert('密码错误!')</script>"); return; } dr1.Close(); //sqlcon.Close(); } else { this.Page.RegisterStartupScript("ss", "<script>alert('用户名不存在!')</script>"); return; } sqlcon.Close(); } else { this.Page.RegisterStartupScript("ss", "<script>alert('验证码输入错误!')</script>"); return; } } } catch (Exception ex) { this.Page.RegisterStartupScript("ss", "<script>alert('验证码输入错误,请刷新页面!')</script>"); } } protected void Button2_Click(object sender, EventArgs e) { } }