classinfo.aspx.cs

学生寝室管理系统

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 ;
public partial class classinfo : System.Web.UI.Page
{
    SqlCommand  cmd,cmd1;
    SqlConnection  cn;
    SqlDataReader  dr,dr1;
    SqlDataAdapter  da,da1;
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
    string strcon, strsql,strsql1,strsql2;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            if (!this.IsPostBack)
            {

                cn = sqldata.createcon();
                cn.Open();
                strsql = "select ximing from ximing ";
                cmd = new SqlCommand(strsql, cn);
                dr = cmd.ExecuteReader();
                this.ddlximing.DataSource = dr;
                this.ddlximing.DataTextField = "ximing";
                this.ddlximing.DataBind();
                this.ddlximing.Items.Add("所有系名");
                this.ddlximing.SelectedIndex = this.ddlximing.Items.Count - 1;
                dr.Close();
                cn = sqldata.createcon();
                cn.Open();
                strsql1 = "select * from users ";
                da = new SqlDataAdapter(strsql1, cn);
                da.Fill(ds1);
                this.mydatagrid2.DataSource = ds1.Tables[(0)].DefaultView;
                this.mydatagrid2.DataBind();
                cn.Close();
            }
        }
    }
  
    protected void mydatagrid2_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.mydatagrid2.CurrentPageIndex = e.NewPageIndex;
        string ximing = this.ddlximing.SelectedItem.Value.ToString();
        
        cn = sqldata.createcon();
        cn.Open();
        strsql1 = "select * from users ";
        da = new SqlDataAdapter(strsql1, cn);
        da.Fill(ds1);

        if (ximing == "所有系名")
        {
            this.mydatagrid2.DataSource = ds1.Tables[(0)].DefaultView;

        }
        else
        {
            DataView ximingds = new DataView(ds1.Tables[0]);
            ximingds.RowFilter = "userdepartment='" + ximing + "'";
            this.mydatagrid2.DataSource = ximingds;

        }
        this.mydatagrid2.DataBind();
        
    }
    protected void mydatagrid2_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
         if (e.Item.ItemType == ListItemType.Item || e.Item .ItemType == ListItemType.AlternatingItem)
        {
            e.Item.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#808080'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
        }
    }
   
    protected void mydatagrid2_SelectedIndexChanged(object sender, EventArgs e)
    {
       
    }

    protected void ddlximing_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.mydatagrid2.CurrentPageIndex = 0;
        string ximing = this.ddlximing.SelectedItem.Value.ToString();
        cn = sqldata.createcon();
        cn.Open();
        strsql1 = "select * from users ";
        da = new SqlDataAdapter(strsql1, cn);
        da.Fill(ds1);
        if (ximing == "所有系名")
        {
            this.mydatagrid2.DataSource = ds1.Tables[(0)].DefaultView;

        }
        else
        {
            DataView ximingds = new DataView(ds1.Tables[0]);
            ximingds.RowFilter = "userdepartment='" + ximing + "'";
            this.mydatagrid2.DataSource = ximingds;
      
        }
        this.mydatagrid2.DataBind();
    }
}