login控件重载登陆方法
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.Data.Sql; using System.Data; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { //获得登陆控件上是各属性值 string stdXh = Login1.UserName; string password = Login1.Password; //生成sql语句和参数对象 string sql = "select count(*) from stdInfo where stdXh=@stdXh and stdMm=@stdMm"; SqlParameter[] param ={ new SqlParameter("@stdXh",SqlDbType.Char), new SqlParameter("@stdMm",SqlDbType.VarChar) }; param[0].Value = stdXh; param[1].Value = password; //执行SQL语句 int usercount = ((int)(sqlHelp.ExecuteScalar(sqlHelp.ConnectionStringLcalTransaction, CommandType.Text, sql, param))); //判断登陆是否成功 if (usercount > 0) { e.Authenticated = true;//设置登录判断变量 //如果登陆成功,将学号保存在session中,供后面成绩查询页面读取 Session["stdXh"] = stdXh; } else e.Authenticated = false;//设置登录判断变量 } }