homeinfo.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 homeinfo : System.Web.UI.Page
{
    SqlCommand  cmd;
    SqlConnection  cn;
   SqlDataReader  dr;
   SqlDataAdapter  da;
    DataSet ds = new DataSet();
    string strcon, strsql;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.databindlist();
    }
    private void databindlist()
    {
        cn = sqldata.createcon();
        cn.Open();
        strsql = "select distinct homeflood,homehao,homecount,homephone,homefen,homesex from home ";
        da = new SqlDataAdapter (strsql, cn);
        da.Fill(ds);
        this.mydatagrid1.DataSource = ds.Tables[(0)].DefaultView;
        this.mydatagrid1.DataBind();
    }
    protected void mydatadrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.mydatagrid1.CurrentPageIndex = e.NewPageIndex;
        this.databindlist();
    }
    protected void mydatadrid1_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 mydatagrid1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}