发布时间 : 星期四 文章aspnet课设--学生成绩管理系统更新完毕开始阅读
using System.Data;
using System.Data.SqlClient; using System.Data.OleDb;
public partial class ogin : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) { }
protected void butsubmit_Click(object sender, EventArgs e) {
if(Page.IsValid) {
string name = username.Text.Trim(); string psw = password.Text.Trim(); string xuehao = xh.Text.Trim(); string xingming = xm.Text.Trim(); string xingbie = xb.Text.Trim(); string banji = Bj.Text.Trim(); string zhuanye = Zy.Text.Trim(); string sfzh = Sfzh.Text.Trim(); string jia = jtdz.Text.Trim(); string cssj = Rq.Text.Trim();
string sql = \values(@username,@password,@xh,@xm,@xb,@Bj,@Zy,@Sfzh,@jtdz,@Rq)\;
SqlParameter[] parameters = { new SqlParameter(\,name), new SqlParameter(\,psw), new SqlParameter(\,xuehao), new SqlParameter(\,xingming), new SqlParameter(\,xingbie), new SqlParameter(\,banji), new SqlParameter(\,zhuanye), new SqlParameter(\,sfzh), new SqlParameter(\,jia), new SqlParameter(\,cssj) };
using (SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\)) {
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())//tsql {
9
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters); cmd.ExecuteNonQuery(); } }
Response.Write(@\注册成功!');\); } }
protected void btnback_Click(object sender, EventArgs e) {
Response.Redirect(\);//返回主界面 } }
4.2.2 老师注册页面
图 老师注册页面
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.OleDb; using System.Data;
public partial class loginfirst : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
10
}
protected void btnlogin_Click(object sender, EventArgs e) {
Response.Redirect(\);//进入学生注册页面 }
protected void btnlogin2_Click(object sender, EventArgs e) {
Response.Redirect(\);//进入教师注册页面 }
protected void btn2_Click(object sender, EventArgs e)//进入教师页 {
string name = username.Text.Trim(); string psw = password.Text.Trim();
SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\);
SqlCommand cmd = new SqlCommand(\ + name + \ + psw + \, conn); DataSet ds = new DataSet(); conn.Open();
SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) {
Session[\] = dr[\].ToString().Trim(); Session[\] = dr[\].ToString().Trim(); Response.Redirect(\); } else
l1.Text = \登陆失败!\; }
protected void btn1_Click(object sender, EventArgs e)//进入学生页 {
string name = username.Text.Trim(); string psw = password.Text.Trim();
SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\);
SqlCommand cmd = new SqlCommand(\ + name + \ + psw + \, conn); DataSet ds = new DataSet(); conn.Open();
SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read())
11
{
Session[\] = dr[\].ToString().Trim(); Session[\] = dr[\].ToString().Trim(); Response.Redirect(\); } else
l1.Text = \登陆失败!\;
} }
4.2.3学生学习修改页面
图 学生修改信息页面
using System;
using System.Collections.Generic; using System.Linq; using System.Web;
12