发布时间 : 星期五 文章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