成绩录入.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 教师表.教师编号=001 AND 课程表.课程号=成绩表.课程号 AND 成绩表.任课教师编号=教师表.教师编号";
        SqlConnection cnn;
        SqlDataAdapter da;
        DataSet ds;
        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();
        string strcmd1 = "SELECT 学生表.学号,学生表.姓名,课程表.课程名,成绩,学分 FROM 教师表,成绩表,学生表,课程表 WHERE 教师表.教师编号=001 AND 成绩表.任课教师编号=教师表.教师编号  AND  学生表.学号=成绩表.学号   AND 成绩表.课程号=课程表.课程号 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        da = new SqlDataAdapter(strcmd1, cnn);
        cnn.Open();
        ds = new DataSet();
        da.Fill(ds, "成绩表");
        GridView1.DataSource = ds;
        GridView1.DataBind();
        cnn.Close();
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        string strcnn = "server=.;database=学生成绩智能管理系统;user id=sa;password=sa;";
        string str1,str2;
        int temp=0;
        SqlConnection cnn = new SqlConnection(strcnn);
        string strcmd1 = "SELECT 学号,课程表.课程名,成绩,学分 FROM 教师表,成绩表,课程表 WHERE 教师表.教师编号=001 AND 成绩表.任课教师编号=教师表.教师编号 AND 成绩表.课程号=课程表.课程号 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        SqlCommand cmd1 = new SqlCommand(strcmd1, cnn);
        cnn.Open();
        SqlDataReader rdr = cmd1.ExecuteReader();
        while (rdr.Read())
        {
            str1 = Convert.ToString(rdr["学号"]);
            str2 = Convert.ToString(rdr["成绩"]);
            if(str2=="")
            {
                TextBox1.Text = Convert.ToString(str1);
                temp=1;
                break;
            }
        }
        if(temp==0)
            Response.Write("<script>alert('成绩录入完毕,没有待录入学生！');</script>");
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        string strcnn = "server=.;database=学生成绩智能管理系统;user id=sa;password=sa;";
        SqlConnection cnn = new SqlConnection(strcnn);
        string str1, str2 ,str3="";
        int temp = 0,temp1=0;
        string strcmd = "SELECT  课程表.课程号 FROM 课程表 WHERE  课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        cnn.Open();
        SqlCommand cmd = new SqlCommand(strcmd,cnn);
        SqlDataReader rdr1 = cmd.ExecuteReader();
        if (rdr1.Read())
        {
            str3 = Convert.ToString(rdr1["课程号"]);
            temp1 = 1;
        }
        cnn.Close();
        if(TextBox2.Text=="")
            Response.Write("<script>alert('请输入成绩！');</script>");
        else
        {
        if(temp1==1)
        {
        string strda = "SELECT  成绩表.课程号,成绩表.学号,成绩 FROM 成绩表 WHERE  成绩表.课程号 = " + "'" + str3 + "'" + "AND 成绩表.学号 = " + "'" + TextBox1.Text + "'";
        cnn.Open();
        SqlDataAdapter da = new SqlDataAdapter(strda,cnn);
        DataSet ds=new DataSet();
        da.Fill(ds,"成绩表");
        DataRow row = ds.Tables["成绩表"].Rows[0];
        row["成绩"]=Convert.ToString(TextBox2.Text);
        SqlCommandBuilder scb = new SqlCommandBuilder(da);
        da.Update(ds.Tables["成绩表"]);
        cnn.Close();
        }
        }
        string strcmd2 = "SELECT 学号,成绩 FROM 教师表,成绩表,课程表 WHERE 教师表.教师编号=001 AND 成绩表.任课教师编号=教师表.教师编号 AND 成绩表.课程号=课程表.课程号 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        cnn.Open();
        SqlCommand cmd2 = new SqlCommand(strcmd2, cnn);
        SqlDataReader rdr = cmd2.ExecuteReader();
        while (rdr.Read())
        {
            str1 = Convert.ToString(rdr["学号"]);
            str2 = Convert.ToString(rdr["成绩"]);
            if(str2=="")
            {
                TextBox1.Text = Convert.ToString(str1);
                TextBox2.Text = "";
                temp=1;
                break;
            }
        }
        if (temp == 0)
            Response.Write("<script>alert('成绩录入完毕,没有待录入学生！');</script>");
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strcnn = "server=.;database=学生成绩智能管理系统;user id=sa;password=sa;";
        SqlConnection cnn = new SqlConnection(strcnn);
        string strcmd1 = "SELECT 学生表.学号,学生表.姓名,课程表.课程名,成绩,学分 FROM 教师表,成绩表,学生表,课程表 WHERE 教师表.教师编号=001 AND 成绩表.任课教师编号=教师表.教师编号  AND  学生表.学号=成绩表.学号   AND 成绩表.课程号=课程表.课程号 AND 课程表.课程名 = " + "'" + DropDownList1.Text + "'";
        SqlCommand cmd1 = new SqlCommand(strcmd1, cnn);
        cnn.Open();
        SqlDataReader rdr = cmd1.ExecuteReader();
        GridView1.DataSource = rdr;
        GridView1.DataBind();
        cnn.Close();
    }
}