protected void Button1_Click(object sender, EventArgs e) { SQlHelper db = new SQlHelper(); string sql = "select apo,name from userInfo"; DataTable dt = db.ExcuteQuery("SqlServer", sql);; for (int i = 0; i < dt.Rows.Count - 1; i++) { string a = dt.Rows[i][0].ToString(); string b = dt.Rows[i][1].ToString(); if (TextBox1.Text == a && TextBox2.Text == b) { Label1.Text = "登录成功"; Server.Transfer("default.aspx"); } else { Label1.Text = "登录失败"; } } }