adminteacherfind.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 adminteacherfind : System.Web.UI.Page
{
    SqlCommand cmd, cmd1;
    SqlConnection cn;
    SqlDataReader dr;
    SqlDataAdapter da, da1;
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
    string strsql1, strsql2;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["adminname"] == null)
        {
            Response.Redirect("index.aspx");
        }
    }
    protected void mydatagrid3_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='#d3d3d3'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
        }

    }
    protected void mydatagrid3_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.mydatagrid3.CurrentPageIndex = e.NewPageIndex;
        this.mydatagrid3.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (this.IsValid)
        {
            cn = sqldata.createcon();
            cn.Open();
            strsql1 = "select * from users where teacher='" + this.txtuserid.Text + "'";
            da = new SqlDataAdapter(strsql1, cn);
            da.Fill(ds1);
            this.mydatagrid3.DataSource = ds1.Tables[(0)].DefaultView;
            this.mydatagrid3.DataBind();
            if (this.mydatagrid3.Items.Count == 0)
            {
                this.Panel1.Visible = false;
                this.labmessage.Text = "对不起？要找的" + this.txtuserid.Text.ToString() + "内容还没有找到";
                this.HyperLink1.Visible = true;
            }
            else
            {
                this.Panel1.Visible = true;
                this.HyperLink1.Visible = true;
                this.labmessage.Text = "恭喜！要找的" + this.txtuserid.Text.ToString() + "内容找到了"; ;
            }
        }
    }
}