Default.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;
using System.Linq;
using System.Data.Linq;

public partial class Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
	protected void ibtLogin_Click(object sender,ImageClickEventArgs e)
	{   ///创建ExamineDB数据库的数据上下文
		 ExamineDBDataContext db = new ExamineDBDataContext(OnlineExamineSystem.ExamineDBConnectionString);
		///查询Examinee表
		var query = from ex in db.Examinee
					where ex.Username == tbUsername.Text.Trim() && ex.Password == tbPassword.Text.Trim()
					select ex;
		///获取用户信息，并判断用户登录是否成功
		if(query.Count()>0 )
		{   ///保存用户登录信息
			Session["UserID"] = query.First().ID.ToString();
			Session["Username"] = query.First().Username;		

			///跳转到Select.aspx页面
			Response.Redirect("~/Select.aspx");
		}		
/*
       SqlConnection conn = new SqlConnection();
 conn.ConnectionString = ConfigurationManager.ConnectionStrings["OnlineExamineDBConnectionString"].ConnectionString;
       conn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select * from Examinee where Username = @name and Password =@pwd";
        cmd.Connection = conn;
        SqlParameter para1 = new SqlParameter("@name", tbUsername.Text);
        SqlParameter para2 = new SqlParameter("@pwd", tbPassword .Text);
        cmd.Parameters.Add(para1);
        cmd.Parameters.Add(para2);
        SqlDataReader sdr = cmd.ExecuteReader();
        if (sdr.HasRows)
        {


            Session["Username"] = tbUsername.Text;
            sdr.Close();
            conn.Close();
            Response.Redirect("Select.aspx");

            
        }
        else