成绩分布.aspx.cs

学生管理系统 功能不是很强大 但是很实用

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class 成绩分布 : System.Web.UI.Page
{
    string strname;
    protected void Page_Load(object sender, EventArgs e)
    {
        strname = Convert.ToString(this.Session["name"]);
        string strcnn = "server=.;database=学生成绩智能管理系统;user id=sa;password=sa;";
        string strcmd = "SELECT DISTINCT 课程表.课程名 FROM 教师表,课程表,成绩表 WHERE 教师表.教师编号='" + strname + " 'AND 课程表.课程号=成绩表.课程号 AND 成绩表.任课教师编号=教师表.教师编号";
        SqlConnection cnn = new SqlConnection(strcnn);
        cnn.Open();
        SqlCommand cmd = new SqlCommand(strcmd, cnn);
        SqlDataReader rdr = cmd.ExecuteReader();
        if (!IsPostBack)
        while (rdr.Read())
            DropDownList1.Items.Add(rdr.GetValue(0).ToString());
        cnn.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strcnn = "server=.;database=学生成绩智能管理系统;user id=sa;password=sa;";
        string strcmd1 = "SELECT COUNT(*) FROM 教师表,课程表,成绩表 WHERE 教师表.教师编号='" + strname + " 'AND 课程表.课程号=成绩表.课程号 AND 成绩表.任课教师编号=教师表.教师编号 AND 成绩表.成绩>=90 AND 成绩表.成绩<=100 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        string strcmd2 = "SELECT COUNT(*) FROM 教师表,课程表,成绩表 WHERE 教师表.教师编号='" + strname + " 'AND 课程表.课程号=成绩表.课程号 AND 成绩表.任课教师编号=教师表.教师编号 AND 成绩表.成绩>=80 AND 成绩表.成绩<=90 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        string strcmd3 = "SELECT COUNT(*) FROM 教师表,课程表,成绩表 WHERE 教师表.教师编号='" + strname + " 'AND 课程表.课程号=成绩表.课程号 AND 成绩表.任课教师编号=教师表.教师编号 AND 成绩表.成绩>=60 AND 成绩表.成绩<=80 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        string strcmd4 = "SELECT COUNT(*) FROM 教师表,课程表,成绩表 WHERE 教师表.教师编号='" + strname + " 'AND 课程表.课程号=成绩表.课程号 AND 成绩表.任课教师编号=教师表.教师编号 AND 成绩表.成绩<=60 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        SqlConnection cnn = new SqlConnection(strcnn);
        cnn.Open();
        SqlCommand cmd = new SqlCommand(strcmd1, cnn);
        TextBox1.Text = Convert.ToString(cmd.ExecuteScalar()) + "人";
        cmd.CommandText = strcmd2;
        TextBox2.Text = Convert.ToString(cmd.ExecuteScalar()) + "人";
        cmd.CommandText = strcmd3;
        TextBox3.Text = Convert.ToString(cmd.ExecuteScalar()) + "人";
        cmd.CommandText = strcmd4;
        TextBox4.Text = Convert.ToString(cmd.ExecuteScalar()) + "人";
        cnn.Close();
    }
}