userdel.aspx.cs

xiexie ,以后会更新的xiexie ,以后会更新的xiexie ,以后会更新的xiexie ,以后会更新的xiexie ,以后会更新的

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;

public partial class login_sysUser_userDel : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        //对数据源进行绑定
        DataSet ds = bc.GetDataSet("select * from tbUser", "tbUser");
        GridView1.DataSource = ds.Tables[0];
        //设置项的主键字段名称,以便后面使用
        GridView1.DataKeyNames = new string[] { "id" };
        GridView1.DataBind();
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //删除信息命令
        string strSql = "delete from tbUser where id='"+GridView1.DataKeys[e.RowIndex].Value+"'";
        //对信息进行删除操作
        bc.ExecSql(strSql);
        //提示删除成功
        Response.Write(bc.MessageBox("删除成功！"));

        //重新对数据源进行绑定(至关重要)
        GridView1.DataSource = bc.GetDataSet("select * from tbUser", "tbUser");
        GridView1.DataBind();
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //提醒用户是否真的要删除
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            ((LinkButton)(e.Row.Cells[4].Controls[0])).Attributes.Add("onclick", "return confirm('确定删除吗？')");
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#aabbcc'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");
        }
    }

    //实际上还可以加一个分页操作
}