masterpage.master.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 users_MasterPage : System.Web.UI.MasterPage
{
    SqlConnection cn;
    string strsql;
    SqlDataAdapter da;
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            int num = 1;
            cn = sqldata.createcon();
            cn.Open();
            strsql = "select* from tongzhi where show="+num ;
            da = new SqlDataAdapter(strsql, cn);
            da.Fill(ds);
            this.dltongzhi.DataSource = ds.Tables[(0)].DefaultView;
            this.dltongzhi.DataBind();
            if (this.dltongzhi.Items.Count == 0)
            {
                this.dltongzhi.Visible = false;
                this.Panel1.Visible = true;

            }
            else
            {
                this.dltongzhi.Visible = true;
                this.Panel1.Visible = false;
            }
        }
        
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Session["username"] ="";
        Session["shenfen"] = null;
        Session["userid"] =null;
        Response.Redirect("index.aspx");
    }
}