aspnet课设- 学生成绩管理系统

using ; using ;

public partial class ogin : Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void butsubmit_Click(object sender, EventArgs e) {

if (Page.IsValid) {

string name = (); string psw = (); string xuehao = (); string xingming = (); string xingbie = (); string banji = (); string zhuanye = (); string sfzh = (); string jia = (); string cssj = ();

Session[\] = xh.ToString().Trim(); string sql = \

username=@username,password=@password,xm=@xm,xb=@xb,Bj=@Bj,Zy=@Zy,Sfzh=@Sfzh,jtdz=@jtdz,Rq=@Rq where xh=@xh\;

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()) {

cmd.CommandText = sql; (parameters);

cmd.ExecuteNonQuery(); } }

Response.Write(@\修改成功！');\); } }

protected void btnback_Click(object sender, EventArgs e) {

Response.Redirect(\);//返回学生界面 } }

4.2.4 老师信息修改页面

图4老师信息修改

using System; using ;

using System.Linq; using System.Web; using ; using ; using ;

public partial class Tealogin : Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void btnSubmit_Click(object sender, EventArgs e) {

// string uid = (); string yong = (); string pwd = (); string ke = ();

Session[\] = teacheruid.ToString().Trim();

string sql = \teacheruid=@teacheruid \;

SqlParameter[] parameters = { new SqlParameter(\, yong), new SqlParameter(\, pwd), //new SqlParameter(\ new SqlParameter(\, ke)};

using (SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\)) {

conn.Open();

//Session[\ using (SqlCommand cmd = conn.CreateCommand())//tsql {

cmd.CommandText = sql; (parameters);

cmd.ExecuteNonQuery(); } }

Response.Write(@\修改成功！');\); }

protected void Button1_Click(object sender, EventArgs e) {

Response.Redirect(\); } }

4.2.5 老师录入成绩页面

图 老师录入成绩页面果

using System; using ;

using System.Linq; using System.Web; using ; using ; using ;

public partial class TeaInput : Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void TextBox5_TextChanged(object sender, EventArgs e) { }

protected void Button1_Click(object sender, EventArgs e) {

//string uid = (); string xuehao = (); string xingming = (); string banji = (); string xueqi = (); string ke = (); string chengji = (); string shijian = ();

string sql = \values(@xh,@xm,@Bj,@xq,@kmm,@cj,@rq)\;

SqlParameter[] parameters = {// new SqlParameter(\ new SqlParameter(\, xuehao), new SqlParameter(\, xingming), new SqlParameter(\, banji), new SqlParameter(\, xueqi), new SqlParameter(\, ke), new SqlParameter(\, chengji), new SqlParameter(\, shijian)};

using (SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\)) {

conn.Open();

using (SqlCommand cmd = conn.CreateCommand())//tsql {

cmd.CommandText = sql; (parameters);

cmd.ExecuteNonQuery(); } } }

protected void Button2_Click1(object sender, System.EventArgs e) {

Response.Redirect(\);//返回 } }

4.2.6学生成绩查询

图 学生成绩查询

using System; using ;

using System.Linq; using System.Web; using ; using ;

using System.Data; using ; using ;

public partial class stu : Page {

protected void Page_Load(object sender, EventArgs e) {

lb.Text = (string)Session[\]; }

protected void Button3_Click(object sender, EventArgs e) {

Response.Redirect(\); }

protected void Button1_Click(object sender, EventArgs e) {

SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\); string km = kmm.Text;

// string cheng= chengji.Text; conn.Open();

SqlCommand comm = new SqlCommand(\ + km + \\, conn);

DataSet ds = new DataSet();

SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) {

this.chengji.Text = dr.GetString(dr.GetOrdinal(\));//获得数据 } } }

4.2.7 老师统计成绩查询

图 老师统计成绩查询

using System; using ;

using System.Linq; using System.Web; using ; using ; using ;

using System.Data; using ;

public partial class tea : Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void Button1_Click(object sender, EventArgs e) {

Response.Redirect(\);//成绩页面 }