protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { if ("是" == Session["SuperAdmin"].ToString()) { SqlData_2 da = new SqlData_2(); da.ExceSQL("delete from tb_Admin where ID='" + gvAdmin.DataKeys[e.RowIndex].Value + "'"); Page.Response.Redirect("AdminManage.aspx"); } else { Response.Write("<script language=javascript>alert('非超级管理员不能进行删除操作!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"] == null) { Response.Redirect("../../Index.aspx"); } SqlData_2 da = new SqlData_2(); this.gvAdmin.DataSource = da.ExceDS("select * from tb_Admin"); gvAdmin.DataKeyNames = new string[] { "id" }; gvAdmin.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData_2 da = new SqlData_2(); string search = this.ddlSearch.SelectedValue; switch (search) { case "管理员ID": da.BindData(this.gvAdmin, "Select * From tb_Admin Where ID Like '%" + this.txtKey.Text + "%'"); break; case "用户名": da.BindData(this.gvAdmin, "Select * From tb_Admin Where UserName Like '%" + this.txtKey.Text + "%'"); break; case "QQ": da.BindData(this.gvAdmin, "Select * From tb_Admin Where QQ Like '%" + this.txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }