test.aspx.cs

程序学生信息管理系统(SQL2000+ASP.NET+c#+)

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 System.Data.SqlClient;

using SMS;

public partial class _Default : System.Web.UI.Page
{
    static string x = null;

    OPDataBase op = new OPDataBase();
    protected void Button1_Click(object sender, EventArgs e)
    {
        x = "2";

        Session["Name"] = "我";
        Label1.Text = Session["Name"].ToString();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        x = "100";
        Session["Name"] = "你";
        Label1.Text = Session["Name"].ToString();
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        Label2.Text = x;
        x = null;
    }
    //  DropDownList控件的使用。

    #region
    //  protected void Page_Load(object sender, EventArgs e)
    // {    //连接数据库；
    //     string sqlstr = ConfigurationSettings.AppSettings["dsn"];
    //SqlConnection conn = new SqlConnection(sqlstr);
    //     //执行查询命令，并填充到数据阅读器里； 
    //     if (!IsPostBack)
    //     {
    //         conn.Open();
    //         SqlCommand cmd = new SqlCommand("select*from Student ", conn);
    //         SqlDataReader dr;
    //         dr = cmd.ExecuteReader();
    //         //绑定到下拉列表；
    //         while (dr.Read())
    //         {
    //             this.DropDownList1.Items.Add(new ListItem(dr["Name"].ToString(), dr["StudentID"].ToString()));

    //         }
    //         conn.Close();

    //     }
    // }
    #endregion
    //
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        // 将下拉列表的对应值显示在TextBox1中；
        // string Sql = "select Class.Desn a ,ClassID,Name,Grade.Desn b,StuNum ,StartDate ,EndDate ,Department.Desn c from Class ,Teacher ,Grade ,Department  where Class.GradeID=Grade.GradeID and Grade.DepartmentID=Department.DepartmentID and Class.TeacherID=Teacher.TeacherID and " + DropDownList1.SelectedValue.ToString() + "='" + DropDownList2.SelectedValue.ToString() + "'";
        string Drvalue = DropDownList1.SelectedValue.ToString();
        string dr_sql;

        SqlDataReader dr;
        switch (Drvalue)
        {
            case "Department.Desn":
                dr_sql = "select Department.Desn h from Department";

                dr = op.getDataReader(dr_sql);
                while (dr.Read())
                {
                    DropDownList2.Items.Add(new ListItem(dr["h"].ToString(), dr["h"].ToString()));

                }
                break;
            case "Grade.Desn":
                dr_sql = "select distinct Grade.Desn v from  Grade   order by Grade.Desn asc";

                dr = op.getDataReader(dr_sql);
                while (dr.Read())
                {





                    DropDownList2.Items.Add(new ListItem(dr["v"].ToString(), dr["v"].ToString()));
                }

                break;
            case "Teacher.Name":
                dr_sql = "select Teacher.Name  x from Teacher";

                dr = op.getDataReader(dr_sql);
                while (dr.Read())
                {
                    DropDownList2.Items.Add(new ListItem(dr["x"].ToString(), dr["x"].ToString()));

                }
                break;

        }
        TextBox1.Text = DropDownList1.SelectedValue.ToString();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        //#region Dropdownlist 控件的绑定;
        //string sqlteacher = "select TeacherID ,Name from Teacher";
        //SqlDataReader dr1;
        //dr1 = op.getDataReader(sqlteacher);
        //if (!IsPostBack)
        //{
        //    while (dr1.Read())
        //    {
        //        DropDownList1.Items.Add(new ListItem(dr1["Name"].ToString(), dr1["TeacherID"].ToString()));
        //    }
        //}
        //#endregion

        string sql = "  select Class.Desn a ,Teacher.Name t ,Grade.Desn b from Class,Teacher,Grade where Class.GradeID=Grade.GradeID  and Class.TeacherID=Teacher.TeacherID";
        op.BinData(sql, GridView1);
        // GridView1.DataKeyNames = new string[] { " a " };

    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        string sql = "   select Class.Desn a ,Teacher.Name t ,Grade.Desn b from Class,Teacher,Grade where Class.GradeID=Grade.GradeID  and Class.TeacherID=Teacher.TeacherID";
        op.BinData(sql, GridView1);
        //  GridView1.DataKeyNames = new string[] { " a " };
    }


    //protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    //{
    //    GridView1.PageIndex = GridView1.PageIndex - 1;
    //}
    //protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    //{
    //    GridView1.PageIndex = GridView1.PageIndex +1;
    //}


    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
        TextBox2.Text = DropDownList2.SelectedValue.ToString();
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        //select Class.Desn a ,Teacher.Name t ,Grade.Desn b from Class,Teacher,Grade where Class.GradeID=Grade.GradeID  and Class.TeacherID=Teacher.TeacherID and Teacher.Name like '毛%'
        string sql = "  select Class.Desn a ,Teacher.Name t ,Grade.Desn b from Class,Teacher,Grade where Class.GradeID=Grade.GradeID  and Class.TeacherID=Teacher.TeacherID and Teacher.Name like '%" + TextBox3.Text.ToString() + "%'";
        op.BinData(sql, GridView1);

        int[] a ={1,2,3 };

        TextBox3.Text = a[0].ToString();

    }
    public void BinData(string str, GridView gridView, string[] field, int[] Cells)
    {
        SqlConnection conn = op.sqlConnection();
        conn.Open();

        SqlDataAdapter da = new SqlDataAdapter(str, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "Table1");
        gridView.DataSource = ds;
        gridView.DataBind();
        DateTime[] dt = new DateTime[1];
        for (int i = 0; i <= gridView.Rows.Count - 1; i++)
        {
            DataRowView drv = ds.Tables["Table1"].DefaultView[i];
            for (int c = 0; c < field.Length; c++)
            {
                string s = field[c].ToString();
                dt[1] = (Convert.ToDateTime(drv[s]));
                //DateTime dt = Convert.ToDateTime(drv[field]);
            }

            foreach (int a in Cells)
            {
                //gridView.Rows[i].Cells[a].Text = dt.ToLongDateString();
                for (int b = 0; b < dt.Length; b++)
                {
                    gridView.Rows[i].Cells[a].Text = dt[b].ToString();
                }
            }
        }

    }
}