deleteuser.aspx.cs

是一个教材管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace BookManager
{
	/// <summary>
	/// DeleteUser 的摘要说明。
	/// </summary>
	public class DeleteUser : System.Web.UI.Page
	{

		protected System.Web.UI.WebControls.Button btAddUser;
		protected System.Web.UI.WebControls.DataGrid dgUser;
		protected System.Data.SqlClient.SqlDataAdapter sqlAdapter;
		protected System.Data.SqlClient.SqlConnection sqlConn;
		protected BookManager.dsUser dsUserInfo;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		protected System.Web.UI.WebControls.Button btDeleteUser;

	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{	
				this.bindS();
			}
		}
		private void bindS()
		{
			sqlAdapter.Fill(dsUserInfo);
			dgUser.DataBind();
		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.sqlAdapter = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConn = new System.Data.SqlClient.SqlConnection();
			this.dsUserInfo = new BookManager.dsUser();
			((System.ComponentModel.ISupportInitialize)(this.dsUserInfo)).BeginInit();
			this.btAddUser.Click += new System.EventHandler(this.btAddUser_Click);
			this.btDeleteUser.Click += new System.EventHandler(this.btDeleteUser_Click);
			this.dgUser.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgUser_ItemCreated);
			this.dgUser.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgUser_ItemCommand);
			this.dgUser.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgUser_DeleteCommand);
			// 
			// sqlAdapter
			// 
			this.sqlAdapter.SelectCommand = this.sqlSelectCommand1;
			this.sqlAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								 new System.Data.Common.DataTableMapping("Table", "tblRole", new System.Data.Common.DataColumnMapping[] {
																																																			new System.Data.Common.DataColumnMapping("RoleName", "RoleName"),
																																																			new System.Data.Common.DataColumnMapping("UserName", "UserName"),
																																																			new System.Data.Common.DataColumnMapping("Email", "Email"),
																																																			new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																			new System.Data.Common.DataColumnMapping("UserId", "UserId")})});
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT tblRole.RoleName, tblUser.UserName, tblUser.Email, tblRole.ID, tblUser.ID " +
				"AS UserId FROM tblRole INNER JOIN tblUser ON tblRole.ID = tblUser.Role";
			this.sqlSelectCommand1.Connection = this.sqlConn;
			// 
			// sqlConn
			// 
			this.sqlConn.ConnectionString = "workstation id=QMX;packet size=4096;user id=sa;data source=\"QMX\\THUNDER\";persist " +
				"security info=True;initial catalog=BookManager;password=gliu0307";
			// 
			// dsUserInfo
			// 
			this.dsUserInfo.DataSetName = "dsUser";
			this.dsUserInfo.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dsUserInfo)).EndInit();

		}
		#endregion

		private void btDeleteUser_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("DeleteUser.aspx");
		}

		private void btAddUser_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("AdminUser.aspx");
		}

		private void dgUser_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sqlStr;
			e.Item.Attributes.Add("onclick", "return confirm('您真的要删除所选项吗？');");
			sqlStr="delete  from tblUser where ID="+e.Item.Cells[0].Text.ToString();
			this.ExecSql(sqlStr);
			this.bindS();
		}
		private void ExecSql(string sqlStr)
		{
			SqlCommand cmd=new SqlCommand(sqlStr,sqlConn);
			sqlConn.Open();
			cmd.ExecuteNonQuery();
			sqlConn.Close();
		}

		private void dgUser_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			switch(e.Item.ItemType)
			{
				case ListItemType.Item:
				case ListItemType.EditItem:
				case ListItemType.AlternatingItem:
					Button 	  myDeleteButton = (Button)e.Item.FindControl("btDelete");
					myDeleteButton.Text = "删除";
					myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除吗？');");
					break;
			}
		}

		private void dgUser_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="UsrDelete")
				dgUser_DeleteCommand(source,e);
		}
	}
}