湖南商学院学年论文设计
strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\
OleDbConnection conn = new OleDbConnection(strconn); string ygID, ygPa, strSql; ygID = TextBox1.Text.Trim(); ygPa = TextBox2.Text.Trim();
strSql = \姓名 from 员工 where 姓名='\\密码='\
OleDbCommand cmd = new OleDbCommand(strSql, conn); DataSet ds = new DataSet();
OleDbDataAdapter ad = new OleDbDataAdapter(cmd);// ad.Fill(ds, \员工\
if (ds.Tables[\员工\ {
Label4.Text = \员工姓名或密码错误\ } else {
Response.Redirect(\查询.aspx\ } } }
第 16 页 共 38 页
湖南商学院学年论文设计
4.3.2 找回密码
public partial class 找回密码 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
string strconn;
strconn = \
+ \考试\\\\App_Data\\\\学生宿舍管理.mdb\ OleDbConnection conn = new OleDbConnection(strconn); conn.Open(); string sq1;
sq1 = \提示问题 from 提示问题\ OleDbCommand cnd = new OleDbCommand(); cnd.Connection = conn; cnd.CommandText = sq1;
DropDownList1.DataSource = cnd.ExecuteReader(); DropDownList1.DataTextField = \提示问题\ DropDownList1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) {
string strconn;
第 17 页 共 38 页
湖南商学院学年论文设计
strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\
OleDbConnection conn = new OleDbConnection(strconn); string name, kh_question, kh_answer,kh_sq1; name = TextBox1.Text.Trim();
kh_question = DropDownList1.Text.Trim(); kh_answer = TextBox2.Text.Trim();
kh_sq1 = \员工姓名 from 员工资料 where 员工姓名='\提示问题='\问题答案='\
OleDbCommand cmd = new OleDbCommand(kh_sq1, conn);
DataSet ds = new DataSet();
OleDbDataAdapter ad = new OleDbDataAdapter(cmd);//??? ad.Fill(ds, \员工资料\
if (ds.Tables[\员工资料\ {
Label.Text = \对不起，你的回答错误！请重新选择，然后回答，谢谢！\ } else {
Response.Redirect(\信息查询.aspx\
第 18 页 共 38 页
湖南商学院学年论文设计
} } }
4.3.3 信息查询
public partial class 查询 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) { }
protected void Button1_Click(object sender, EventArgs e) {
OleDbConnection conn = new OleDbConnection(); string strconn;
strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\ conn.ConnectionString = strconn; conn.Open();
string sql, kh_name, kh_number;
kh_name= DropDownList1.Text.Trim() + \ kh_number = DropDownList3.Text.Trim() + \ sql = \学生信息 \ \学生姓名 like'\
第 19 页 共 38 页
湖南商学院学年论文设计
\学号 like '\ OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = sql;
GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); } }
4.3.4 卫生评比
public partial class 卫生评比 : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
TextBox11.Text = DateTime.Now.ToString(); OleDbConnection conn = new OleDbConnection(); string strconn;
strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\ conn.ConnectionString = strconn; conn.Open(); }
protected void Button1_Click(object sender, EventArgs e)
第 20 页 共 38 页