userindex.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 userindex : System.Web.UI.Page
{
    SqlCommand  cmd, cmd1, cmd2, cmd3;
    SqlConnection  cn;
   SqlDataReader dr;
    SqlDataAdapter  da, da1,da2,da3;
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
    DataSet ds2 = new DataSet();
    DataSet ds3 = new DataSet();
    string strcon, strsql, strsql1, strsql2, strsql3;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["shenfen"] == "室员")
        {
            this.PopupWin1.Message = "欢迎访问！您的身份是室员" + "<br>" + "您的ＩＰ->" + Request.UserHostAddress + "<br>" + "您使用的浏览器->" + Request.Browser.Type + " &nbsp;版本是->" + Request.Browser.Version + "<br>" + "您使用的操作系统->" + Request.Browser.Platform + "<br>";
            this.PopupWin1.Text = "欢迎访问！学生寝室管理系统！" + "<br>" + "您的身份是室员,请正确的使用你的权力" + "<br>" + "您的ＩＰ->" + Request.UserHostAddress + "<br>" + "您使用的浏览器->" + Request.Browser.Type + " &nbsp;版本是->" + Request.Browser.Version + "<br>" + "您使用的操作系统->" + Request.Browser.Platform + "<br>" + "谢谢您的支持！我会继续努力的";
        }
        else
        {
            this.PopupWin1.Message = "欢迎访问！您的身份是寝室长" + "<br>" + "您的ＩＰ->" + Request.UserHostAddress + "<br>" + "您的浏览器->" + Request.Browser.Type + " &nbsp;版本是->" + Request.Browser.Version + "<br>" + "您使用的操作系统->" + Request.Browser.Platform + "<br>";
             this.PopupWin1.Text = "欢迎访问！学生寝室管理系统！"+"<br>"+"您的身份是寝室长,请正确的使用你的权力" + "<br>" + "您的ＩＰ->" + Request.UserHostAddress + "<br>" + "您的浏览器->" + Request.Browser.Type + " &nbsp;版本是->" + Request.Browser.Version + "<br>" + "您使用的操作系统->" + Request.Browser.Platform + "<br>"+"谢谢您的支持！我会继续努力的";
        }
        string youxiu = "是";

        cn = sqldata.createcon();
        cn.Open();
        strsql = "select distinct homesex,homeflood,homehao,homecount,homephone from home";
        da = new SqlDataAdapter (strsql, cn);
        da.Fill(ds);
        this.mydatadrid1 .DataSource = ds.Tables[(0)].DefaultView;
        this.mydatadrid1 .DataBind();

        strsql1 = "select * from users order by userid desc";
        da1 = new SqlDataAdapter (strsql1, cn);
        da1.Fill(ds1);
        this.mydatagrid2.DataSource = ds1.Tables[(0)].DefaultView;
        this.mydatagrid2.DataBind();

        strsql2 = "select distinct homeflood,homehao,homecount,homephone,homefen,homesex from home where  homeyn='" + youxiu+"'" ;
        da2 = new SqlDataAdapter (strsql2, cn);
        da2.Fill(ds2);
        this.mydatagrid3.DataSource = ds2.Tables[(0)].DefaultView;
        this.mydatagrid3.DataBind();

        strsql3 = "select * from homebad order by id desc";
        da3 = new SqlDataAdapter (strsql3, cn);
        da3.Fill(ds3);
        this.mydatagrid4.DataSource = ds3.Tables[(0)].DefaultView;
        this.mydatagrid4.DataBind();
    }
}