adminnotics.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 adminnotics : System.Web.UI.Page
{
    SqlConnection cn;
    SqlDataAdapter da;
    SqlCommand cmd, cmd1;
    DataSet ds = new DataSet();
    SqlDataReader dr1, dr;
    string strsql, strsql1;
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!this.IsPostBack)
        {
            if (Session["adminname"] == null)
            {
                Response.Redirect("index.aspx");
            }
            else
            {
                this.databindlist();
            }
        }
    }
    private void databindlist()
    {

        cn = sqldata.createcon();
        cn.Open();
        strsql = "select*from tongzhi";
        da = new SqlDataAdapter(strsql, cn);
        da.Fill(ds);
        this.mydatagrid3.DataKeyField = "id";
        this.mydatagrid3.DataSource = ds.Tables[(0)].DefaultView;
        this.mydatagrid3.DataBind();
        if (this.mydatagrid3.Items.Count == 0)
        {
            this.Panel1.Visible = false;
            this.labmessage.Text = "本站到现在还没有公告,请快添加公告吧！";
            this.HyperLink1.Visible = true;
        }
        else
        {
            this.Panel1.Visible = true ;
            this.labmessage.Visible = false;
        }
    }
    protected void mydatagrid3_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        int id = Convert.ToInt32(this.mydatagrid3.DataKeys[e.Item.ItemIndex].ToString());
        cn = sqldata.createcon();
        cn.Open();
        strsql1 = "delete from tongzhi where id='" + id + "'";
        cmd1 = new SqlCommand(strsql1, cn);
        cmd1.ExecuteNonQuery();
        this.databindlist();
        this.Label2 .Text = "删除成功";
    }
    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");
            ((LinkButton)(e.Item.Cells[5].Controls[0])).Attributes.Add("onclick", "return confirm('您确认要删除吗?');");
        }
    }
    protected void mydatagrid3_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {

        this.mydatagrid3.CurrentPageIndex = e.NewPageIndex;
        this.databindlist();
    }
}