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

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;

cmd.Parameters.AddRange(parameters); cmd.ExecuteNonQuery(); } } }

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

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

4.2.6学生成绩查询

图 学生成绩查询

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.Data;

17

using System.Data.SqlClient; using System.Data.OleDb;

public partial class stu : System.Web.UI.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 老师统计成绩查询

图 老师统计成绩查询

18

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.Data.Odbc; using System.Data;

using System.Data.SqlClient;

public partial class tea : System.Web.UI.Page {

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

protected void Button1_Click(object sender, EventArgs e) {

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

protected void Button2_Click(object sender, EventArgs e) {

Response.Redirect(\);//修改页面 }

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

protected void Button3_Click(object sender, EventArgs e) {

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

SqlCommand comm = new SqlCommand(\ + KMM + \order by cj desc \, conn);

DataSet ds = new DataSet();

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

//获得数据

this.TextBox2.Text = dr.GetString(dr.GetOrdinal(\)); } }

19

protected void Button4_Click(object sender, EventArgs e) {

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

SqlCommand comm = new SqlCommand(\chengji group by Bj,kmm order by avgcj desc;\, conn); DataSet ds = new DataSet();

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

//获得数据

this.TextBox4.Text = dr.GetString(dr.GetOrdinal(\)); } }

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

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

protected void Button5_Click(object sender, EventArgs e) {

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

20