admin_score.aspx.cs

包含了几个由sql server2005开发的典型程序

using System;
using System.Data;
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;
using GROUP.Manage;

public partial class admin_score : System.Web.UI.Page
{
    //创建公共类BaseClass（包含与数据库操作的方法）的对象  
    BaseClass BaseClass1 = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        String strSql = "select DISTINCT 班级.班级名称,班级.班级编号 from 班级 where 班级.教职工编号 = '" + Session[0].ToString() + "' order by 班级.班级编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        if (DropDownList1.Items.Count == 1)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DropDownList1.Items.Add(dt.Rows[i].ItemArray[0].ToString().Insert(2,"级").Insert(7,"班") );
            }
        }
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
        string str1 = TextBox1.Text.Substring(0, 2) + TextBox1.Text.Substring(3, 4);
        String strSql = "select DISTINCT 教程.学期,课程.课程名称,教程.班级编号 from 课程,教程,班级 where 课程.课程编号 = 教程.课程编号 and 教程.班级编号 = 班级.班级编号 and 班级.班级名称 = '" + str1 + "' order by 教程.学期";
        DataTable dt = BaseClass1.ReadTable(strSql);
        Session["banji_number"] = dt.Rows[0].ItemArray[2].ToString();
        DropDownList1.Text = "请选择班级：";
        DropDownList2.Items.Clear();
        DropDownList2.Items.Add("请选择课程");
        DropDownList3.Items.Clear();
        DropDownList3.Items.Add("请选择学生：");
        TextBox2.Text = "请输入成绩：";
        if (DropDownList2.Items.Count == 1)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                str1 = dt.Rows[i].ItemArray[0].ToString().Insert(3, "学期").Insert(2, "年第");
                DropDownList2.Items.Add(str1 + " " + dt.Rows[i].ItemArray[1].ToString());
            }
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string str1 = DropDownList1.Text.Substring(0, 2) + DropDownList1.Text.Substring(3, 4);
        String strSql = "select DISTINCT 教程.学期,课程.课程名称,教程.班级编号,课程.课程编号 from 课程,教程,班级 where 课程.课程编号 = 教程.课程编号 and 教程.班级编号 = 班级.班级编号 and 班级.班级名称 = '" + str1 + "' order by 教程.学期,课程.课程编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        Session["banji_number"] = dt.Rows[0].ItemArray[2].ToString();
        TextBox1.Text = "或者请输入班级：";
        DropDownList2.Items.Clear();
        DropDownList2.Items.Add("请选择课程：");
        DropDownList3.Items.Clear();
        DropDownList3.Items.Add("请选择学生：");
        TextBox2.Text = "请输入成绩：";
        if (DropDownList2.Items.Count == 1)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                str1 = dt.Rows[i].ItemArray[0].ToString().Insert(3, "学期").Insert(2, "年第");
                DropDownList2.Items.Add(str1+" " + dt.Rows[i].ItemArray[1].ToString());
            }
        }        
    }
    void bindgrig()
    {
        string str_term = DropDownList2.Text.Substring(0, 2);
        str_term = str_term.Insert(2, DropDownList2.Text.Substring(4, 1));
        string strSql = "select 学生.姓名,成绩.成绩,学生.学生编号 from 学生,成绩,教程,课程 where 学生.班级编号 = '" + Session["banji_number"].ToString() + "' and 成绩.学生编号 = 学生.学生编号 and 成绩.教程编号 = 教程.教程编号 and 教程.学期= '" + str_term + "' and 教程.课程编号 = 课程.课程编号 and 课程.课程名称= '" + DropDownList2.Text.Substring(8) + "' order by 学生.学生编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        DataTable dat = new DataTable();
        DataColumn dc1 = new DataColumn("学生姓名1", Type.GetType("System.String"));
        DataColumn dc2 = new DataColumn("学生成绩1", Type.GetType("System.String"));
        DataColumn dc3 = new DataColumn("学生姓名2", Type.GetType("System.String"));
        DataColumn dc4 = new DataColumn("学生成绩2", Type.GetType("System.String"));
        DataColumn dc5 = new DataColumn("学生姓名3", Type.GetType("System.String"));
        DataColumn dc6 = new DataColumn("学生成绩3", Type.GetType("System.String"));
        DataColumn dc7 = new DataColumn("学生姓名4", Type.GetType("System.String"));
        DataColumn dc8 = new DataColumn("学生成绩4", Type.GetType("System.String"));
        DataColumn dc9 = new DataColumn("学生姓名5", Type.GetType("System.String"));
        DataColumn dc10 = new DataColumn("学生成绩5", Type.GetType("System.String"));
        dat.Columns.Add(dc1);
        dat.Columns.Add(dc2);
        dat.Columns.Add(dc3);
        dat.Columns.Add(dc4);
        dat.Columns.Add(dc5);
        dat.Columns.Add(dc6);
        dat.Columns.Add(dc7);
        dat.Columns.Add(dc8);
        dat.Columns.Add(dc9);
        dat.Columns.Add(dc10);
        for (int i = 0; i < dt.Rows.Count / 5; i++)
        {
            DataRow dr = dat.NewRow();
            for (int j = 0; j < 5; j++)
            {
                dr[j * 2] = dt.Rows[i * 5 + j].ItemArray[0].ToString();
                dr[j * 2 + 1] = dt.Rows[i * 5 + j].ItemArray[1].ToString();
            }
            dat.Rows.Add(dr);
        }
        DataRow dr1 = dat.NewRow();
        for (int j = 0; j < dt.Rows.Count % 5; j++)
        {
            dr1[j * 2] = dt.Rows[(dt.Rows.Count / 5) * 5 + j].ItemArray[0].ToString();
            dr1[j * 2 + 1] = dt.Rows[(dt.Rows.Count / 5) * 5 + j].ItemArray[1].ToString();
        }
        dat.Rows.Add(dr1);
        //填充记录        
        //设置GridView数据源
        GridView1.DataSource = dat;
        //显示数据
        GridView1.DataBind();
    }

    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
        string str_term = DropDownList2.Text.Substring(0, 2);
        str_term = str_term.Insert(2, DropDownList2.Text.Substring(4, 1));
        String strSql = "select 学生.姓名,学生.学生编号 from 学生 where 学生.班级编号 = '" + Session["banji_number"].ToString() + "' order by 学生.学生编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        DropDownList3.Items.Clear();
        DropDownList3.Items.Add("请选择学生：");
        TextBox2.Text = "请输入成绩：";
        if (DropDownList3.Items.Count == 1)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DropDownList3.Items.Add(dt.Rows[i].ItemArray[0].ToString());
            }
        }
        bindgrig();
    }
    protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
    {
        TextBox2.Text = "";
        TextBox2.Focus();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {        
        if(DropDownList3.SelectedIndex == 0)
        {
            DropDownList3.Text = DropDownList3.Items[1].ToString();
            TextBox2.Text = "";
            TextBox2.Focus();
            return;
        }
        string str_term = DropDownList2.Text.Substring(0, 2);
        str_term = str_term.Insert(2, DropDownList2.Text.Substring(4, 1));
        string strSql = "select 成绩.编号 from 学生,成绩,教程,课程 where 学生.班级编号 = '" + Session["banji_number"].ToString() + "' and 学生.姓名 = '" + DropDownList3.Text + "' and 成绩.学生编号 = 学生.学生编号 and 成绩.教程编号 = 教程.教程编号 and 教程.学期= '" + str_term + "' and 教程.课程编号 = 课程.课程编号 and 课程.课程名称= '" + DropDownList2.Text.Substring(8) + "' order by 学生.学生编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        strSql = "update 成绩 set 成绩 = " + TextBox2.Text + " where 成绩.编号 = '" + dt.Rows[0].ItemArray[0].ToString() + "'";
        BaseClass1.execsql(strSql);
        bindgrig();
        if (DropDownList3.SelectedIndex == (DropDownList3.Items.Count-2))
        {
            Button1.Text = "第一个";
            DropDownList3.Text = DropDownList3.Items[DropDownList3.SelectedIndex + 1].ToString();
        }
        else if (DropDownList3.SelectedIndex == (DropDownList3.Items.Count - 1))
        {
            DropDownList3.Text = DropDownList3.Items[1].ToString();
            Button1.Text = "下一个";
        }
        else
        {
            DropDownList3.Text = DropDownList3.Items[DropDownList3.SelectedIndex + 1].ToString();
        }
        TextBox2.Text = "";
        TextBox2.Focus();
    }
}