userdel.aspx.cs

使用SQL Server为后台数据库ASP.NET C#语言开发-set OA system, using SQL Server database for background ASP.NET C#

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 manage_sysUser_userDel : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.DataSource = bc.GetDataSet("select * from tbUser","tbUser");
        GridView1.DataKeyNames = new string[] {"id" };
        GridView1.DataBind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        bc.ExecSQL("delete from tbUser where id='"+GridView1.DataKeys[e.RowIndex].Value+"'");
        GridView1.DataSource = bc.GetDataSet("select * from tbUser", "tbUser");
        GridView1.DataBind();
    }
}