default3.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 Default3 : System.Web.UI.Page
{
    //static bool x = false;
    string student;
    protected void Page_Load(object sender, EventArgs e)
    {
        student = this.Session["name"].ToString();
        if (DropDownList1.Text == "")
        {
            string str = "";
            string myConnstr = "data source=localhost;database=学生成绩智能管理系统;user id=sa;password=sa;";
            SqlConnection myConn = new SqlConnection(myConnstr);
            string sql = "select distinct 成绩表.日期 from 成绩表,学生表,课程表 where 成绩表.课程号=课程表.课程号 and 成绩表.学号='" + student + "' and 学生表.学号='" + student + "'";
            myConn.Open();
            //成绩表.学号,学生表.姓名,成绩表.成绩,课程表.课程名,
            SqlCommand myComm = new SqlCommand(sql, myConn);
            SqlDataReader myDataReader = myComm.ExecuteReader();
            while (myDataReader.Read())
            {
                if (str != myDataReader.GetValue(0).ToString())
                {
                    this.DropDownList1.Items.Add(myDataReader.GetValue(0).ToString());
                }
                str = myDataReader.GetValue(0).ToString();
            }
            myConn.Close();
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
    }
    protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int x=0;
        string myConnstr = "data source=localhost;database=学生成绩智能管理系统;user id=sa;password=sa;";
        SqlConnection myConn = new SqlConnection(myConnstr);
        string sql = "select 成绩表.学号,学生表.姓名,成绩表.成绩,课程表.课程名,成绩表.日期,课程表.学分 from 成绩表,学生表,课程表 where 成绩表.课程号=课程表.课程号 and 成绩表.学号='" + student + "' and 学生表.学号='" + student + "' and 课程表.课程号=成绩表.课程号 and 成绩表.日期='" + DropDownList1.Text + "'";
        myConn.Open();
        SqlCommand myComm = new SqlCommand(sql, myConn);
        SqlDataReader myDataReader = myComm.ExecuteReader();
        while (myDataReader.Read())
        {
            if (int.Parse(myDataReader.GetValue(2).ToString()) >= 60)
            {
                x += int.Parse(myDataReader.GetValue(5).ToString());
            }
        }
        TextBox1.Text = Convert.ToString(x);
        myConn.Close();
        myConn.Open();
        myComm = new SqlCommand(sql, myConn);
        myDataReader = myComm.ExecuteReader();
        GridView1.DataSource = myDataReader;
        GridView1.DataBind();
        myConn.Close();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("登陆页面.aspx");
    }
}